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

Compare DR solution using hardware level like Storage function and Software level like log shipping or database mirroring.. Expand / Collapse
Author
Message
Posted Sunday, January 19, 2014 7:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 26, 2014 8:29 PM
Points: 2, Visits: 4
I am a storage admin. I have a project about comparing between DR solution. In the original my company use disk replicate (hardware level) but when testing unplan DR on database application it mostly occurs problem to recovery so DBA change the way to use software feature as Log Shipping, Database Mirroring and Always On either one.

Please help me to explain what significant different between them because I am storage admin when I read many article or forum somtimes I still confuse. If show me the picture or diagram maybe help me more understand clearly

Thanks in advance
Natta R.
Post #1532449
Posted Tuesday, May 6, 2014 9:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:24 AM
Points: 373, Visits: 1,235

Disk replication or SAN to SAN replication, replicates or move the saved data on disk to a different location. The problem with this is, that database engines like MS-SQL keep open transactions on memory. So if that's not taken into consideration, when you attach the database or files on the remote location, you may end with corrupted or broken databases.

Log Shipping solves that because it is basically replicating everything, including transactions. It does that moving transactions over the network and applying that on the remote SQL server.

With Veritas Cluster, you can actually combine both. You deploy SQL server using Veritas (one local one remote) but you use SAN to SAN replication as well.
Post #1568017
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse