Post reply

In-Place upgrade to SQL Server 2008 Vs Log shipping

  • April 26, 2010 at 5:23 pm

    #386793

    Hi,

    We have SQL Server 2005 EE x64 with SP3 and all the databases in that instance are configured with log shipping. Now the requirement is to In-place upgrade to SQL Server 2008 EE

    Question:

    1. Do I need to Disable the log shipping before starting the upgrading and reconfigure the log shipping from the scratch in new upgraded SQL Server 2008 insatnce? or

    2. Does the SQL Server log shipping automatically converted to SQL Server 2008 log shipping format?

    3. How to deal the same in Active/Passive cluster setup?

    Thanks

  • April 27, 2010 at 1:28 am

    #1158004

    Upgrade to SQL Server 2008 - Upgrade Assistance and Tools

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • April 30, 2010 at 11:12 am

    #1160617

    Hi Paul,

    What happens to the secondary SQL Server 2005 instance, if we upgrade the primary SQL Server 2005 instance in which the databases were configured with log shipping to SQL Server 2008?

    Will the secondary SQL Server 2005 instance also got upgraded to SQL Server 2008 automatically?

    How to deal with the secondary SQL Server 2005 instance, after upgrading the Primary SQL Server 2005 instance to SQL Server 2008?

    Thanks

  • May 3, 2010 at 12:36 pm

    #1161444

    I do have the same question. Could you please advice on what tasks need to done to upgrade the secondary too, while upgrading the primary?

    thanks

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

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