how often we need to update the windows patches in production and reboot them?

  • Hi,

    I just wanted to know how often we need to update the windows patches for SQL Server in production?

    We have a 3 node a/a/p set up.

    How we need to plan the Server reboots in cluster environment after applying the patches?

    Thanks

  • Ideally every time a new update comes out. realistically we install updates at least once a month if they are needed.

    As far as how to reboot the servers? Sounds like a great way to test your disaster recovery fail-over plans to me. You have plans for when a server "Unexpectedly" drops like a good administrator right??


    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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