?
Solved

SQL Server 2008 upgrade to R2 with log shipping involve

Posted on 2010-11-10
1
Medium Priority
?
665 Views
Last Modified: 2012-05-10
Hello,

I am trying to find a way to upgrade SQL 2008 to R2. My scenario is the following:

A) Log Shipping between a Primary and Secondary Server

B) (1) SQL Server 2008 Cluster as the PRIMARY

C) (1) SQL Server 2008 as the SECONDARY (Read-only mode) because of log shipping.

D) Windows Server 2008 on all the servers



What is the best way to accomplish an upgrade to SQL Server 2008 R2 on both Primary and Secondary without causing a disaster?



Thank you,
0
Comment
Question by:snazaire
1 Comment
 
LVL 8

Accepted Solution

by:
gothamite earned 2000 total points
ID: 34277003
So you have one cluster at your primary site and a standalone machine at your secondary site?

If that is the case I would do the following:

1. Upgrade the secondary (standalone) machine to SQL 2008 R2. Log shipping should still work although it must be configured in NORECOVERY mode i.e. not STANDBY. If you are not currently in this mode I would change that as your first task. The database cannot be brought online because it would try to upgrade the database to a R2 version which won't be possible.

2. Upgrade the Primary cluster. The log shipping should get upgraded and continue to restore to the newly upgraded standby server.

Obviously you should test this process in a test environment etc.,
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

831 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