October 20, 2005 at 7:58 am
Guys,
I have installed SP4 onto a test Server and want to test the rollback instructions from MS.
Has anyone done this?
Is says to
Detach all user DBs
Uninstall SQL Server 2000
Re-install SQL Server 2000
Restore master, model and msdb
Re-attach all user DBs
Is there not an easier way to roll back?
Regards
Carl
October 20, 2005 at 8:45 am
I have actually run through the process of rolling the SP 4 back and it worked fine. It does seem overly complex, but I think due to the number of updates there is probably not an easy way to do it.
October 20, 2005 at 8:51 am
Thanks.
If I'm going to re-install SQL will it over-write the data files in the default data directory?
I've copied the files to another folder in case.
October 20, 2005 at 9:51 am
As of the last time I checked, no. Microsoft hasn't built in a roll-back capability like they do with OS hotfixes and service packs because SQL Server is very much a different animal. For instance, a lot of service packs have updates to the system objects, like if they're fixing a replication bug and the like. Hence the reason for having to restore the old system databases and the like.
K. Brian Kelley
@kbriankelley
October 20, 2005 at 9:55 am
Thanks Brian.
I moved my system dbs from the default folders when I initially installed SQL Server. Will I need to set up my system dbs the same way. Even though I am going to restore the master, model and msdb before re-attaching my User Dbs?
Regards
Carl
August 25, 2006 at 1:48 pm
any special instructions when doing this on a ms cluster? or is it the same
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply