Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

SQL Server Enterprise cluster replication and Service Pack level consideration

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
Senior IT System Engineer
Asked:
Senior IT System Engineer
1 Solution
 
Kent DyerIT Security Analyst SeniorCommented:
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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now