Home Forums SQL Server 2008 SQL Server Newbies SQL Server upgrade from 2008 Enterprise SP3 to SQL 2008 R2 Enterprise SP3 RE: SQL Server upgrade from 2008 Enterprise SP3 to SQL 2008 R2 Enterprise SP3

  • February 12, 2016 at 12:24 pm

    #1858491

    bobba (2/12/2016)

    We need to upgrade a cluster named instance. SQL Server is currently 2008 SP3 Enterprise 64 bit. We want to upgrade to SQL Server 2008 R2 SP3 Enterprise. I'd go to SQL 2012 however right now that is not an option.

    This would be an inplace upgrade. I'd like to take a snapshot of the server however with the cluster that is not an option. The way I see it, upgrade SQL, then install the service packs.

    Is there anything I'm missing. Any other steps to include? Comments / URLs are always appreciated.

    Thanks.

    You only need the latest service pack, it has everything from the previous service packs. I may be wrong, but if the service pack is available in the directory from which you install SQL Server 2008 R2 it should be slip streamed and installed as you install R2.