MS SQL 2000 Backup to MS SQL 2008 Restore

Thread needs solution
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Posts: 2
Comments: 1

Hello,

I am trying to restrore a SQL 2000 DB into SQL 2008.
Here's what I did:

1 - Backup SQL 2000 DB with Acronis SQL backup on Source server to a USB drive.
2 - Moved backup to Destination server.
3 - Ran Acronis SQL restore on Destination server.

The task shows completely successfully in the Acronis SQL Console.
However, in the SQL Server 2008 Management Studio, the restored database shows (Restoring...) for the last 7 hours.

The database is 115GB.
Any thoughts as to whether this is going to be successful?

If this fails, my thoughts are to upgrade the source server to SQL 2005, then back it up and restore to destination server. Basically go from SQL 2005 to SQL 2008.

Thanks for any help or insight.
Cepolly

Sun, 04/04/2010 - 17:26
0 Users found this helpful
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Forum Star
Posts: 24
Comments: 3268

Hello Carmine!

Welcome on Forum and thank you for finding time to share your concerns with us, we really appreciate that!

Thank you for the detailed ddescription of the problem, it helped a lot! I have searched our resources and found a mention, that we had such issues in the previous builds of the software. So the best solution for us here is to install the latest build and try to restore once again.

I have just forwarded a PM to you with the needed links and instructions, please kindly follow them to resolve the issue.

I would also appreciate if you could keep us updated regarding the case, so that we could provide you with further assistance if needed. 

Should you need anything else or have any further questions - feel free to contact us at your earliest convenience, we will be happy to help you!

Thank you!

Tue, 04/06/2010 - 15:55
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Posts: 2
Comments: 1

Hi Yana,

Thanks for your response
I apologize that my reply is long in coming

Basically to resolve this issue I detached the SQL 2000 db in question on the source server, copied it to an external storage device, connected the device to the destination server with SQL 2008, copied it to the SQL db folder & then attached it to the instance.

There was a bit of tweaking such as correcting logins and linking tables but all worked out in the end.

Thanks again.
Carmine

Sun, 04/11/2010 - 20:09
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Forum Star
Posts: 24
Comments: 3268

Dear Carmine!

Thank you very much for finding time to report that the issue was resolved, I'm really glad to know it. And many thanks for specifying the steps which led to the resolution - this informaiton is very important not only for us, but for the entire community! Thank you for cooperation.

Should you need anything else or have any further concerns - just let us know, we will be happy to assist you!

Thank you.

Tue, 04/13/2010 - 15:14
truwrikodrorowrelupicugojestutroclulachosaswunuhospikigawakijosaswenomaruclojeueclikaspedrubewidebrisubrohutrurifruuagothunugekedrumucisiuobrobrecrupeslapuswosluprothethibakaslechurathikucli
Beginner
Posts: 0
Comments: 1

Greetings. I am a new poster....I'm not sure if this is the right place but the others mention SQL 2008....

I have a database in SQL 2008 that I don't know if I messed up one of the fields with redefining it thru a third part software. Is there any way of retoring a table to the active database from a backup and have it be renamed so as to keep the actual active table un changed/untouched ?

Thanx,

Jeff

Thu, 10/27/2011 - 14:34