sql data recovery?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • crs
    #1

    sql data recovery?

    To the point....

    My company received a disc containing our last year's database
    information from the online company that we use for our documentation(
    They use SQL ). Only thing is, we are a small business and do not have
    a "server", therefore we do not have sql server, therefore we can't get
    our documentation off of the disc. The thing is, we're being
    accredited next week and I need this information for accreditation
    purposes. I need to know if there is another option to retrieve this
    information without purchasing Microsoft Server and SQL Server.

    any advice / help would be much appreciated.

    CRS

    Tags: None
    • Roy Harvey
      #2
      Re: sql data recovery?

      What files are on the CD? Are you sure they are SQL Server files?

      SQL Express is a free version of SQL Server 2005. It has limits, but
      there is a good chance your need for a database server falls within
      them. It can be downloaded from the Microsoft web site. Include the
      SQL Server Express Toolkit if you try this.

      You may still have serious issues with getting AT your data - this is
      a database, not a front end application - but it is a step.

      Roy Harvey
      Beacon Falls, CT

      On 1 Dec 2006 11:55:17 -0800, "crs" <claytonrstone@ gmail.comwrote:
      >To the point....
      >
      >My company received a disc containing our last year's database
      >information from the online company that we use for our documentation(
      >They use SQL ). Only thing is, we are a small business and do not have
      >a "server", therefore we do not have sql server, therefore we can't get
      >our documentation off of the disc. The thing is, we're being
      >accredited next week and I need this information for accreditation
      >purposes. I need to know if there is another option to retrieve this
      >information without purchasing Microsoft Server and SQL Server.
      >
      >any advice / help would be much appreciated.
      >
      >CRS

        Comment

        • crs
          #3
          Re: sql data recovery?

          Thanks for the quick reply.

          the only thing on the disc is one .bak file

          Roy Harvey wrote:
          What files are on the CD? Are you sure they are SQL Server files?
          >
          SQL Express is a free version of SQL Server 2005. It has limits, but
          there is a good chance your need for a database server falls within
          them. It can be downloaded from the Microsoft web site. Include the
          SQL Server Express Toolkit if you try this.
          >
          You may still have serious issues with getting AT your data - this is
          a database, not a front end application - but it is a step.
          >
          Roy Harvey
          Beacon Falls, CT
          >
          On 1 Dec 2006 11:55:17 -0800, "crs" <claytonrstone@ gmail.comwrote:
          >
          To the point....

          My company received a disc containing our last year's database
          information from the online company that we use for our documentation(
          They use SQL ). Only thing is, we are a small business and do not have
          a "server", therefore we do not have sql server, therefore we can't get
          our documentation off of the disc. The thing is, we're being
          accredited next week and I need this information for accreditation
          purposes. I need to know if there is another option to retrieve this
          information without purchasing Microsoft Server and SQL Server.

          any advice / help would be much appreciated.

          CRS

            Comment

            • Roy Harvey
              #4
              Re: sql data recovery?

              On 1 Dec 2006 12:41:12 -0800, "crs" <claytonrstone@ gmail.comwrote:
              >Thanks for the quick reply.
              >
              >the only thing on the disc is one .bak file
              So once you have SQL Server running, you will have to use the RESTORE
              command.

              Roy

                Comment

                • Greg D. Moore \(Strider\)
                  #5
                  Re: sql data recovery?


                  "Roy Harvey" <roy_harvey@sne t.netwrote in message
                  news:g051n29sne u5fgdshpr528bd5 ch9t330t2@4ax.c om...
                  On 1 Dec 2006 12:41:12 -0800, "crs" <claytonrstone@ gmail.comwrote:
                  >
                  >>Thanks for the quick reply.
                  >>
                  >>the only thing on the disc is one .bak file
                  >
                  So once you have SQL Server running, you will have to use the RESTORE
                  command.
                  >
                  Note if the DB is over 4GB in size SQL Express won't work.

                  But it's possible you may be able to use a 120 day trial version if you just
                  need to get the data out once and that's it.

                  Roy

                    Comment

                    • crs
                      #6
                      Re: sql data recovery?

                      But it's possible you may be able to use a 120 day trial version if you just
                      need to get the data out once and that's it.
                      >
                      >
                      Roy
                      Thanks for the trial idea, worked like a charm. I was able to beat my
                      deadline by 4 hours.
                      Thanks!

                        Comment

                        • Greg D. Moore \(Strider\)
                          #7
                          Re: sql data recovery?


                          "crs" <claytonrstone@ gmail.comwrote in message
                          news:1165374361 .968245.318830@ f1g2000cwa.goog legroups.com...
                          >But it's possible you may be able to use a 120 day trial version if you
                          >just
                          >need to get the data out once and that's it.
                          >>
                          >>
                          Roy
                          >
                          Thanks for the trial idea, worked like a charm. I was able to beat my
                          deadline by 4 hours.

                          See... that's 4 hours now you can spend with pizza, beer and some wings!

                          Thanks!
                          >

                            Comment

                            Previous template Next
                            Working...