Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to another storage array?

Also I want to mirror the DB to a DR site. Is log shipping ideal for this situation?

Thanks in advance,


share|improve this question
In SQL Server 2012, database mirroring is deprecated. What ever DR solution you choose, it will depend on how much downtime is acceptable and how much you are willing to loose - RTO and RPO. What version of SQL Server are you using ? – Kin Jan 30 '14 at 3:56
@Kin Thanks for your reply. I'm using MS SQL Server 2012 on Windows Server 2012. Our main site is connected via MPLS fiber link to the DR site. Pretty much it can handle Log Shipping traffic. One hour downtime is acceptable. – trevzeuq Jan 31 '14 at 3:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.