Solved

SQL Server Enterprise cluster replication and Service Pack level consideration

Posted on 2011-09-02
1
176 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

815 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

11 Experts available now in Live!

Get 1:1 Help Now