Rolling back from Service Pack 4

  • 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

     

  • 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.

  • 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.

     

     

  • 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

  • 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

  • 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