Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eapranger2
Starting Member
4 Posts |
 Posted - 2010-05-05 : 13:55:54
|
| How do you move a sql server 2000db on to a sql server 2008 so the DB will be in standby mode? Can log shipping be done between 2000 and 2008? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-05 : 14:14:08
|
| I think this dubious because:Is your application tested to run on SQL2008 - or are you just assuming it will work? If you have the hardware for a stand-by server presumably the application is mission critical, and if that's the case I would be wanting to test that the application runs OK on SQL2008 on the stand-by server, and if it did I would then want to upgrade the primary to SQL2008 once I'd done the tests - otherwise any change to the Primary must also be tested to work OK under SQL 2008 - which just prolongs the agony, and you can't take advantage of any new features in SQL 2008 as they aren't supported on your Primary machine's SQL 2000.Having said that I don't see why this wouldn't work. You can restore SQL 2000 backups onto SQL 2008 using NORECOVERY and the server will sit there waiting for more backups files to restore ...However, unlike a normal stand-by server, when you DO use the RECOVERY option to put it live there will be an additional delay whilst the database is upgraded to SQL 2008 - and if the database is large that might be a considerable time - which may not be good from a disaster-recovery / business-continuity standpoint.Hints and Tips on upgrading to SQL 2008 here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
 |
|
|
|
|
|
Restore sql server 2000 DB on sql server 2008