May 1, 2008 at 10:09 pm
hello,
As part of the upgrade plan, I need to create a rollback process that will let me stop
the upgrade from sql server 2000 to 2005 at any point during the process and bring the old databases and installations back online until we can solve any problem encountered during the
upgrade.
so could you please tell me some rollback processes?
thanx
May 1, 2008 at 10:40 pm
My approach, I don't do upgrade!
Get a new server and install your new 2005 on the new server. If the install failed, well your old server is up and running. When everything is up, you could backup from 2000 and restore to 2005 server, test it for a while before you do the final backup from 2000 and restore to 2005.
It is going to be ugly if you have to shut down and restart the server a couple of time when you do sql 2005 installs and you will be taking your production box down with it if you go the upgrade route.
Sopheap
May 2, 2008 at 1:27 am
I agree with Sopheap........maximum server uptime is always the primary duty of a DBA.....:)
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply