Unsolved

This post is more than 5 years old

13 Posts

988

December 24th, 2008 11:00

Restore SQL to a new server

Quick question.

We are getting ready to roll out a new SQL 2008 box and as a test, we would like to restore our large Datawarehouse DB to the new server rather than moving the live db.

Anyone know of any gotcha's or things to watch for when restoring a SQL database to a new server?

13 Posts

December 24th, 2008 11:00

Forgot to mention the live SQL box is SQL 2000 and we will be restoring to a new 64 bit SQL 2008 box. Does that complicate things any???

2 Intern

 • 

2K Posts

December 24th, 2008 11:00

Do restore the master, msdb and other standard SQL databases to ensure you get all correct informaiton there.

2 Intern

 • 

2K Posts

December 25th, 2008 21:00

I think it should complicate...not good at SQL but believe that there would be a some good architectural differenc e between SQL 2008 and SQL 2000 and thereofre it may not accept the database as is.

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

January 2nd, 2009 07:00

I would be surprised to hear MS would support that...

443 Posts

January 2nd, 2009 16:00

This might not work. You might need to dump out the data from your SQL 2000 and import it to SQL 2008. Would suggest you look at what MS recommends to migrate data from SQL 2000 to SQL 2008. I don't think a restore of your SQL 2000 data from a backup into a SQL 2008 server is really a viable method of upgrading / migrating.

0 events found

No Events found!

Top