?
Solved

SQL Server 2008 upgrade to R2 with log shipping involve

Posted on 2010-11-10
1
Medium Priority
?
663 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 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 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