Solved

SQL Server 2008 upgrade to R2 with log shipping involve

Posted on 2010-11-10
1
659 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 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Detach & Attach 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.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

773 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