SAN to SAN hardware level (Block Level) replication solution for MSSQL 2008 R2 databases synchronization between DR and Production

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » SAN to SAN hardware level (Block Level)...

SAN to SAN hardware level (Block Level) replication solution for MSSQL 2008 R2 databases synchronization between DR and Production

Rate Topic

Display Mode

Topic Options

Author

Message

ali.siddiqui 79140

Posted Friday, March 01, 2013 3:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 01, 2013 6:50 AM
Points: 1, Visits: 4

Hi;

Appreciate your suggestions and solution for following scenario

Scenario:
======

1) My SAN team already implemented SAN to SAN replication between disaster recovery and production site
2) SAN to SAN replicaiton solution is hardware level/block level replication solution provided by vendor
3) I have one MSSQL 2008 R2 cluster at production site and one MSSQL 2008 R2 cluster at disaster recovery
4) MSSQL databases mdf and ldf files are on SAN storage

Q1 - As per above scenario, Will it transfer databases mdf and ldf files from production SAN to DR SAN, or is there any complexity to synch mdf and ldf files by using SAN to SAN hardware level\block level replication?
Q2 - In case of production failure can I attach database mdf and ldf file at DR site? or Is there any extra step will be required to attach mdf and ldf file

Post #1425412

GilaMonster

Posted Friday, March 01, 2013 3:56 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:49 PM
Points: 37,671, Visits: 29,925

First ensure that the SAN replication preserves write order and is certified to work with SQL Server databases. If not, then you've got a russian roulette DR solution there. Also make sure that the latency on the replication does not result in unacceptably slow IOs on the production server.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1425426

BuntyBoy

Posted Tuesday, March 05, 2013 11:53 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, April 27, 2013 9:30 PM
Points: 392, Visits: 384

In our environment we are not preferring this scenario and would rather request to opt out the mdf. ndf and ldf files as it have caused issues during DR exercise....

===========================================
Better try and fail than not to try at all...

Database Best Practices

SQL Server Best Practices

Post #1426971

« Prev Topic | Next Topic »

Permissions