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

Topic

New Reply

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.

Reply | Quote

Replies

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/Prudent patcher

Reply | Quote

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.

 

Reply | Quote

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

cheers, Paul

Reply | Quote

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

Reply | Quote

Export as VMDK then import?

cheers, Paul

Reply | Quote

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.

Reply | Quote