Restore SQL to a new server

Question

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?

toleolu · Answer

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???

amediratta · Answer

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

amediratta · Answer

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.

ble1 · Answer

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

Hari5 · Answer

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.

NetWorker

Restore SQL to a new server

Was this post helpful?