Solved

SQL Server Enterprise cluster replication and Service Pack level consideration

Posted on 2011-09-02
1
173 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
Comment Utility
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
A procedure for exporting installed hotfix details of remote computers using powershell
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

771 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

12 Experts available now in Live!

Get 1:1 Help Now