Search code examples
sql-server-2008disaster-recovery

How can I achieve Disaster Recovery (DR) in simple recovery model

**One of my client do not want any change in existing SQL Server 2008, which has 42 Databases (around 70 GB total size) and all databases are in simple recovery mode.

I need to replicate data for Disaster Recovery in same scenario. The acceptable downtime with data loss is 30 minuets. How can i do this, plz help.. !**

Solution
    • Switch to Full recovery mode and implement log shipping
    • Implement mirroring
    • If neither is practical, do full backups nightly, and differential backups every 30 minutes, ship them to your standby.

    No matter what solution you go with, test the recovery process to make sure it meats the RTO, and make sure your SQL servers are licensed properly.