locked
Best practices for keeping an off-line SQL Server 2008 up to date? RRS feed

  • Question

  • Hi,

    I am new to SQL Server. Any body know of any best practices for keeping an off-line SQL Server up to date?

    I of cause have to install SP when they are released. I have found the cumulative updates that contains hot fixes, but they should not be installed unless we have a problem that is addressed by one of the hot fixes. So what about security patches?

    Regards Peter

     

    Tuesday, July 27, 2010 3:25 PM

Answers

  • Yes that is correct. I have not installed any hot fix on our boxes but only SP1
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Tom Li - MSFT Thursday, July 29, 2010 12:26 PM
    • Marked as answer by Tom Li - MSFT Thursday, August 5, 2010 2:16 AM
    Wednesday, July 28, 2010 8:07 AM

All replies

  • Yes that is correct. I have not installed any hot fix on our boxes but only SP1
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Tom Li - MSFT Thursday, July 29, 2010 12:26 PM
    • Marked as answer by Tom Li - MSFT Thursday, August 5, 2010 2:16 AM
    Wednesday, July 28, 2010 8:07 AM
  • And I normally keep the security patches (SQL Server and Windows) applied to the server.

    RLF

    • Proposed as answer by Tom Li - MSFT Thursday, July 29, 2010 12:26 PM
    • Unproposed as answer by Tom Li - MSFT Thursday, July 29, 2010 12:26 PM
    Wednesday, July 28, 2010 3:30 PM
  • Thanks Uri
    Thursday, August 5, 2010 6:23 AM
  • Thanks Russell. Where do I get the SQL Server security patches?

    Regards Peter

    Thursday, August 5, 2010 6:25 AM
  • I mentioned patching both Windows and SQL Server.  Whatever you choose to do, you can check the Microsoft Security Bulletins here:

    http://www.microsoft.com/security/updates/bulletins/

    We don't usually rush these out right away, but we schedule them for application.

    RLF

    Thursday, August 5, 2010 12:22 PM