Upgrade SQLServer from 2005 to 2008 (primary and standby )

Posted on 2012-08-16
Last Modified: 2012-09-04

  I am planning to upgrade my SQLserver 2005 x64 (standard)  to SQLServer 2008 .  Can I perform the upgrade without having  to redo my log shipping.

currently , I have 2 servers (Windows server 2008 R2 64bit)

Server A is primary and Server B contain my database in Stand-by mode

Is there a sequence that I should follow to do the upgrade.

Thanks for your help
Question by:SiemensSEN
    LVL 16

    Assisted Solution

    You could do an in-place upgrade but this would involved downtime and to be honest im not 100% sure it wouldnt break log shipping.

    So i suppose the safe answer is no, you would have to redo your log shipping.
    LVL 13

    Expert Comment

    You should be able to perform in-place upgrade and keep your log shipping intact. Sequence-wise - upgrade you stand-by server (Server B) first.

    Don't forget to update statistics (sp_updatestats) after the upgrade.

    Author Comment


    My database on the the remote machine is in Stand-by/read only mode. Can I still do the in-place upgrade
    LVL 13

    Accepted Solution

    Here is the link to Microsoft Whitepapers about that.

    This is for SQL 2012 but technique would work with 2008 too

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now