Post reply

Sql server updates

  • April 26, 2012 at 9:17 am

    #259984

    Hi,

    I am a developer and unfortunately taking care of my database adminstration\maintenance, But its a good chance for me to learn. I don't know how to check whether all my servers are up to date with service packs or updates. How to check this? I have 5 servers running on Sql 2005 and 4 servers on Sql 2008.

  • April 26, 2012 at 10:22 am

    #1479889

    There are a bunch of ways ot tell what version of SQL Server you have. Microsoft has them documented here. The best is to query directly:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Then you have to know what the latest version available are. They're located here. MSDN is your friend.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 26, 2012 at 10:22 am

    #1479890

    You can do SELECT @@version and compare that to this.[/url]

    Jared
    CE - Microsoft

  • April 26, 2012 at 1:23 pm

    #1480040

    Thanks for your reply. Can you help me with this. How to check my server having Sql is up to date with Sql patches or updates. Is there any updates to be downloaded and updated monthly like windows updates?

  • April 26, 2012 at 1:25 pm

    #1480042

    12B (4/26/2012)

    Thanks for your reply. Can you help me with this. How to check my server having Sql is up to date with Sql patches or updates. Is there any updates to be downloaded and updated monthly like windows updates?

    You can do SELECT @@version and compare that to this.

    Jared
    CE - Microsoft

  • April 27, 2012 at 1:00 am

    #1480214

    periodically read the SQL Server Release blog at http://blogs.msdn.com/b/sqlreleaseservices/ to keep up with any updates...

  • April 27, 2012 at 1:03 am

    #1480215

    also check out the Microsoft security bulletin (released on the second Tuesday of every month) http://technet.microsoft.com/en-us/security/bulletin/advance

    Edit: patches here are usually aimed more at your server admins but its good to know what could impact SQL Server and asses the need for the patches yourself

  • April 27, 2012 at 9:24 am

    #1480519

    Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

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