• SQL server 2000 – Need help with restoring databases. Suggestions for utilities

    Home » Forums » AskWoody support » Windows » Windows 10 » Questions: Win10 » SQL server 2000 – Need help with restoring databases. Suggestions for utilities

    Author
    Topic
    #2499779

    I’m hoping someone can help me.  My client has an old application which uses SQL server 2000.  I am trying to transfer the data from one server to another.  The SQL server is running in virtual software (Virtualbox)  .  The host operation system is Windows 7, guest is Windows 2000 pro.

    There are 2 separate computers involved.  Data needs to be transferred from computer C1 to computer C2.  On C1 I can successfully create the backup files for each database.  When I transfer them to C2 and try to restore all I get is a small rectangle with the word Error in it.  Nothing of importance is written to the SQL logs.

    What 3rd party (non Microsoft) utilities could help me restore the data from the backup files?

    Thank you for your help.

    Viewing 2 reply threads
    Author
    Replies
    • #2499846

      On the new computer are your “run as administrator” on the SQL maintenance console?  I’ve even merely “plopped” the database and reconnected it and didn’t use backup/restore.

      Susan Bradley Patch Lady

      • #2502475

        I appreciate your comments.  I need to use backup / restore because I am moving the data from one instance to a different instance.  If I simply detach and attach to the new instance, my understanding is this would fail.   I don’t know what commands I would  need to use to alter the database before attaching to the new instance.

         

    • #2499854

      Why don’t you just lift the VM and drop it on a new machine?

      cheers, Paul

      • #2502476

        Cannot do this.  The old computer is running Virtualbox v3.12, the new computer is running v6.1.

    • #2502477

      I had to do this the hard way.  I exported each table (60 tables)  and then used bcp to insert the data into each table in the new computer.   I would very much like to NEVER do this again.

    Viewing 2 reply threads
    Reply To: SQL server 2000 – Need help with restoring databases. Suggestions for utilities

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: