Post reply

upgrade sql 2005 standard edition from RTM to SP3

  • October 14, 2009 at 11:18 am

    #227133

    hi folks,

    I am new in my company and find out we have a sql 2005 standard RMT version instance installed on vmware.

    If i want to upgrade this instance to sp3, can I direct apply sp3 to it and that's it.

    or i have to apply sp2 and sp3 to call it successful upgrade.

    thanks for your reply.

  • October 14, 2009 at 11:28 am

    #1065865

    You just apply SP3. It is a cumulative update

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • October 14, 2009 at 11:41 am

    #1065876

    thanks for your reply.

    here is I found from List of the bugs that are fixed in SQL Server 2005 Service Pack 3

    If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, you must apply a post-SQL Server 2005 SP3 cumulative update after you upgrade to SQL Server 2005 SP3 to obtain all the fixes.

    if is it means after sp3, i need install sp2 cumulative update 10 or 11.

    also, has sp3 mature enough, or most people still patch sp2 in their server?

    Thanks

  • October 14, 2009 at 12:00 pm

    #1065891

    binxu (10/14/2009)

    thanks for your reply.

    here is I found from List of the bugs that are fixed in SQL Server 2005 Service Pack 3

    If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, you must apply a post-SQL Server 2005 SP3 cumulative update after you upgrade to SQL Server 2005 SP3 to obtain all the fixes.

    if is it means after sp3, i need install sp2 cumulative update 10 or 11.

    also, has sp3 mature enough, or most people still patch sp2 in their server?

    Thanks

    Since you are still at RTM version this would not apply to your instance of SQL. Once you update to SP3 running Windows Update against the server will go out and pull in the SP3 cumulative updates that your server may need. Then you can research each of those to find out if they would need to be applied to your server.

    Prior to applying SP3 be sure to backup + backup + backup.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

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

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