Take the 2-minute tour ×
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. It's 100% free, no registration required.

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,

Trev

share|improve this question
1  
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 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 at 3:19

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.