Solved

SQL Server 2008 upgrade to R2 with log shipping involve

Posted on 2010-11-10
1
661 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
gothamite earned 500 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 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