Solved

SQL Server Enterprise cluster replication and Service Pack level consideration

Posted on 2011-09-02
1
174 Views
Last Modified: 2012-05-12
Hi People,

I'd like to know if it is possible to make the DB replication between sites with different version of SQL Server 2008 like the following:

Production site: Active-Passive SQL Server 2008 R2 SP1
DR site: Active-Passive SQL Server 2008 SP2

if that is not possible can I actually install two types of SQL Server in the DR sites same servers as a cluster ? so it will be like:
DR site:
Active-Passive SQL Server 2008 SP2 - Instance1
Active-Passive SQL Server 2008 R2 SP1 - Instance2

and also if I patch one of the DB 1 within the Production instances SQL Server with SP1 does that affects the other instance as well ?

Production site:
Active-Passive SQL Server 2008 R2 SP1\Instance1\DB1
Active-Passive SQL Server 2008 R2 SP1\Instance1\DB2

Thanks.
0
Comment
1 Comment
 
LVL 17

Accepted Solution

by:
Kent Dyer earned 500 total points
ID: 36476800
You want all of your SQL Boxes to be the same SP level as much as possible.

I would very carefully read the following chart to insure that you are able to complete the task with your version of SQL server:

http://msdn.microsoft.com/en-us/library/cc645993.aspx#Replication

More information on Active Passive, etc.

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/05cf41b7-c558-44bf-86c6-12f5c2b2ffe2

Here is a Word Doc that goes into more detail for you for SQL 2008..
http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

HTH,

Kent
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
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.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now