Post reply

Compare DR solution using hardware level like Storage function and Software level like log shipping or database mirroring..

  • January 19, 2014 at 7:47 am

    #288441

    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.

  • May 6, 2014 at 9:05 am

    #1711120

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply