UNSOLVED
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?
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?
amediratta
2 Intern
•
2014 Posts
583
0
Posted December 24th, 2008 11:00
Do restore the master, msdb and other standard SQL databases to ensure you get all correct informaiton there.amediratta
2 Intern
•
2014 Posts
583
0
Posted 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.- 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.
toleolu
13 Posts
583
0
Posted December 24th, 2008 11:00