SP4 patch

Posted on 2006-06-03
Last Modified: 2008-03-06
What kind of problems might I expect to encounter on applying the SP4 patch to an original installation of SQL 2000 (no upgrades applied)?   I'm scared to death to apply it and am assuming out of the four downloads, it's 32 bit intel as it's and not the MSDE - it's the enterprise edition.  I had someone else set up the server for me, but now I have to make sure it's up to date.
Anyway, I've been putting this off and know it needs to be done, but am wondering what it entails. The "Help/Instructions" are way over my head and need to know if I'll have to detach/reattach all the databases or if anything can go wrong that will put me out of business.
I can't even do it until I get a backup and the system is mirrored and I understand that it's not a simple thing to use Ghost and get a good backup, so I'm posting that as a question as well.  I'm not sure where to post it under, though.
Question by:dcass
    LVL 40

    Assisted Solution

    by:Vadim Rapp
    It's probably not what you want, but why you have to make sure it's up to date? Is it giving you any problems? If not, then don't fix what's not broken, especially in your situation.

    If you do need to update, then you basically have three choices: (1) learn the stuff (2) hire someone who knows the stuff (3) take your chances that everything will be smooth and just run the exe. The right choice, accordingly, depends on the willingness and time to learn the stuff vs. your budget vs. importance of the database.
    LVL 50

    Accepted Solution

    i agree with Vadimrapp1

    but i'm puzzled why you're "scared to death"

    that any patching or upgrading of software isn't something that you just do to the system?

    you need to take a copy of your set up first for test purposes and then apply the patch/upgrades to that
    and only once you've successfully performed that task , AND RIGOROUSLY tested the applications
    and got signoff from your users do you attempt to Apply it into your production environment...

    and as always the first rule with this is ensure that you have full and proper backups of everything
    (and stored separately to the machines your affecting) before attempting to apply anything....
    (and then doing another full backup of the system before letting it back into production...

    LVL 5

    Assisted Solution

    Where is ur application runnning.. same or different box?

    applying SP4 can take anywhere from 12 min to 48 hrs(yes it is hrs)... all it does is updating binaries and system db's.
    So, the best thing is to backup all the databases.. restore on a diff box .. apply sp4 and test the application.

    just a gentle reminder that sp4 (or for that matter any of the sp's or hotfixes) cant be rollbacked. So in case u want to go back to ur original state... reinstall and restore db's.


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now