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

Disaster Recovery - SQL vs VM Disk Replication Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 9:22 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 11:36 AM
Points: 7, Visits: 37
We are evaluating approaches to DR. For SQL Server we have the usual log shipping, replication, and various 'AlwaysOn' methods. The other approach is to use one of the Hypervisor or SAN based disk level replication technologies.

Certainly, one advantage of the SQL approaches is the the system at the remote DR site is 'warm' or even 'hot'.

But I have not been able to find discussions on the relative efficiency of the two approaches. I would imagine that any Hypervisor or SAN based replication needs to replicate ALL the disk writes. That includes the MDF as well as the LDF writes etc., AND any Windows NTFS writes such as the system journal and file attribute structures if the file grows or shrinks. Whereas the SQL methods are really only replicating the resulting DB change, and letting the remote system apply the change.

I would think that the SQL replication could therefore use significantly less network bandwidth between the primary and DR sites.

Does anyone have any experience or opinions here???

Thanks,
Dave



Post #1496456
Posted Thursday, September 19, 2013 9:32 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 13, 2014 7:56 AM
Points: 822, Visits: 1,204
Not really an opinion but I would highly recommend the product Neverfail for DR. It is in my mind a great product at a fraction of the cost of most other options.

Dan

If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Post #1496462
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse