August 9, 2007 at 8:55 am
What kind of back out plan should be employed to apply transactions/data differences made in SQL2K5 back to SQL2K should we decide to back out and flip our switches back to SQL2K? (Restore? DTS? SQL Data Compare?)
August 9, 2007 at 9:40 am
You cannot apply log back ups from 2k5 to 2k. Even if compatability is set to 2000.
I kept the 2000 backup and all the log backups. after testing 2005 was working, I disconnected the DB from web servers, did a last log backup / restore to 2005 and changed the web config to point to new DB.
Not the most seemless route but it was only down for around 5-10 minutes.
Should you after a week want to go back to 2K, transfer DB / DTS is the only option I know of.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 9, 2007 at 9:44 am
All depends really... Restore is not an option as you can not restore a SQL 2005 backup on a SQL 2000 server. So DTS/SSIS would most likely be your only option (could BCP I guess as well).
Also important to decide on before doing the switch to a new server is to have a clearly defined set of circumstances that will require a switch back. And not talking knowing everything that could go wrong, but more along the line of "if we have problems that can't be solved in X minutes, we switch back"
Besides that it is impoertant to have it documented what your plans are in case you have to switch back, and have them tested. Also set up a guideline for how long can business be on the 2005 server before data must be resynched back. This of course depends on the nature of your business but also nature of the problem. If none has been able to get to the server at all to enter new data, there should be no need to resynch it.
August 15, 2007 at 10:01 am
Here's a good thread I found on the Microsoft forums that you can use as a backout plan of 2005 to 2000:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
Scroll down to PanosTz's post.
HTH,
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply