Upgrade SQLServer from 2005 to 2008 (primary and standby )

Posted on 2012-08-16
Medium Priority
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
  • 2
LVL 16

Assisted Solution

EvilPostIt earned 500 total points
ID: 38300921
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

ID: 38302726
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

ID: 38327091

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

dwkor earned 700 total points
ID: 38329323
Here is the link to Microsoft Whitepapers about that. http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf

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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

862 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