+1 (425) Business Continuity Solutions for SQL Database* applications in Windows Azure Alexander (Sasha) Nosov Principal Program Manager Microsoft Corporation * Formerly known as SQL Azure +1 (425) Platform security Physical securityGeo distribution Compliance +1 (425) Reads are completed at the primary Writes are replicated to secondaries Each replica is backed up independently DB Single Logical Database Multiple Physical Replicas P S S Write Ack Read Value Write Ack P S S +1 (425) Primary Manager Node Partition Manager Fabric Data Node 103 P P S S S S Data Node 104 S S S S Data Node 102 P P S S S S Data Node 105 P P S S S S Data Node 101 S S P P P P P P S S S S S S Global Partition Map Node down Which replica lost? Promote to primary Reconfigure S S +1 (425) No additional administration cost ACID properties are maintained by the system Failovers are fully automated Dynamic routing of connections No additional charges for database redundancy RPO=0, RTO=30sec 99.9% availability SLA +1 (425) S S P P S S Azure DNS HostnameIP AddressEuropeContoso service West Europe App admin End user DBCopy Create backup copy DB_06_11_2012 DB_06_12_2012 DB_06_13_2012 Oops! Recover from backup DB_MAINDB_MAIN_OLD ALTER DATABASE DB_MAIN MODIFY NAME = DB_MAIN_OLD GO WAITFOR DELAY '00:00:30' GO ALTER DATABASE DB_06_01_2012 MODIFY NAME = DB_MAIN GO DB_MAIN Minimal charge is prorated day use Copies entire database You are responsible for retention and cleanup Support database federations is coming soon RTO = time to recognize the error + time to rename the database + rename delays +1 (425) Leverages import/export service and Azure storage Reduces storage cost but increases backup time More complex backup/restore workflow RTO = time to recognize the error + time to import database + time to rename the database Contoso service West Europe DBCopy DB_06_01_2012 DB_MAIN BP_06_11_2012 BP_06_12_2012 BP_06_13_2012 Export +1 (425) Azure DNS HostnameIP AddressEuropeContoso V1 (primary instance) West Europe App admin End user DBCopy Create backup copy DB_06_11_2012 DB_06_12_2012 DB_06_13_2012 DB_MAIN Contoso V1 (secondary instance) North Europe DB_MAIN BP_06_11_2012 BP_06_12_2012 BP_06_13_2012 Export to blob Export Import from blob Import Activate and verify application DNS update North Europe Copies entire database You are responsible for cleanup Minimal database charge is prorated day use Support for database federations is coming soon RTO = time to import + time to start app + DNS change RPO = export interval demo Using SQL Database import/export service for disaster recovery of your application +1 (425) Contoso V1 (primary instance) West Europe DBCopy DB_06_01_2012 DB_05_25_2012 DB_05_18_2012 North Europe BP_06_11_2012 BP_06_12_2012 BP_06_13_2012 Geo-replication BP_06_11_2012 BP_06_12_2012 BP_06_13_2012 +1 (425) Extends replica creation and data synchronization to geo User initiated Automatic data replication and synchronization Optional RPO enforcement Read-only geo-secondary Multiple geo-secondaries User-controlled failover P S S P S S +1 (425) Roadmap: Point in time recovery +1 (425) Roadmap: Point in time recovery S S P P Exposes internal backups to the user Backups are highly available Restores to new database Any point in time within retention period +1 (425) Breakout Session: AZR203 Business Continuity in the Windows Azure Cloud AZR204 Hybrid Will Rule: Options to Connect, Extend and Integrate Applications in Your Data Center and Windows Azure Find Me Later At SQL Server booth or +1 (425) mva Microsoft Virtual Academy SQL Server 2012 Eval Copy Get Certified! Hands-On Labs +1 (425) Q & A +1 (425) #msTechEd mva Microsoft Virtual Academy SQL Server 2012 Eval Copy Get Certified! Hands-On Labs +1 (425) Connect. Share. Discuss.Learning Microsoft Certification & Training ResourcesTechNet Resources for IT ProfessionalsResources for Developers EvaluationsSubmit your evals online