none
patch apply question

    Question

  •  

    I got 4 sql2k5 servers with service patch version as following:

    Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86)   Feb  9 2007 17:30:38
    Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows
    NT 5.2 (Build 3790: Service Pack 2)
    Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
    Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
    5.2 (Build 3790: Service Pack 2)
    Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
    Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
    5.2 (Build 3790: Service Pack 2)

    Can anyone please advise me what is the easiest way to upgrade them to the
    most updated patch version? i.e. update path.

    Meanwhile, what is the best practice to apply patches? Do you go to
    microsoft website and check it out daily and apply it or other tricks?
    Please advise. Thanks.
    Monday, February 11, 2008 1:45 AM

Answers