Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    8

    Unanswered: Rolling Back SQL Server 2000 SP 4 to SP 3

    We have installed SQL Server 2000 Service Pack 4 recently and have had various issues with some of our Stored Procedures. (which we didn't have with SP 3)

    We are looking at our options regarding rolling back to Service Pack 3.

    Can this be done ?
    &
    If so, is there a method documented on how to do this ?

    Any advice would be appreciated.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm sure there is a method documented somewhere. I'd check MSDN. The short story boils down to:

    1. Detach database files
    2. Backup master.
    3. Reinstall SQL 2000 RTM
    4. Restore master
    5. Apply sp3a
    6. Reattach database files.

    -PatP

  3. #3
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    U are not alone with this problem.
    check this link,it may shed some light to u.

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58294
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Actually, you have to use a backup of master from before the upgrade to SP4, since SP4 may alter tables/procedures in the master database. I would also reverse steps 4 and 5 in Pat's list, mainly for the same reasons. So:

    1. Detach database files
    2. Uninstall SQL Server
    3. Reinstall SQL 2000 RTM
    4. Apply sp3a
    5. Restore master from pre-upgrade backup
    6. Reattach database files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •