MS03-031

  • I have a general question :

    1.  Once you have applied MS03-031 on SQL Server 2000, do you need to reboot?  [also same for sql server 7.0]

    I saw that one of the articles in the website says you don't need to reboot unless the files are in use while installing the patches.  Then how would I know if it's in use...

     

     

     

  • The installation will tell you whether you need to reboot the server.

  • As a personal 'best practice' I ALWAYS reboot after SP or hotfix installations. You never know when you are going to run into that one instance that will drive you nuts ! And I even do so after an initial installation as well ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • There are a number of services which may be affected by the install, if you don't stop these services you need to reboot - snmp is one service I can think of.

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply