Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SAN to SAN hardware level (Block Level) replication solution for MSSQL 2008 R2 databases synchronization between DR and Production Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 3:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 1, 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
Posted Friday, March 1, 2013 3:56 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,445, Visits: 35,501
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
Posted Tuesday, March 5, 2013 11:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 6:23 AM
Points: 392, Visits: 405
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 »

Add to briefcase

Permissions Expand / Collapse