Transcript Microsoft Azure SQL Database Business Continuity and Auditing

B
)
Transactions
per hour
Transactions
per minute
Transactions
per second
RTO<24h*,
RPO<24h
RTO<24h*,
RPO<24h
RTO<24h*,
RPO<24h
RTO<2h
RPO<30m
RTO<2h
RPO<30m
RTO<1h,
RPO<5m
* Target only, actual time depends on the data size and scale of restores
Azure SQL Database
Customer (subscription owner)
Single Logical
Database
• Critical capabilities:
 Create new replica
 Synchronize data
 Stay consistent
 Detect failures
 Fail over
 99.99% availability
DB
Ack
Value Read
Write
P
Ack
S
Write
Ack
Write
S
Reads are completed at the primary
Writes are replicated to secondaries
RA-GRS
sabcp01bl21
sabcp02bl21
sabcp03bl21
Copy backups to Azure Storage
LS XYZ
DB
Backups
DB1
Backups
Restore as a
new database
from local
backups
RA-GRS
RA-GRS
sabcp01bl21
US West
sabcp02bl21
sabcp01bl21
sabcp03bl21
sabcp02bl21
sabcp03bl21
LS ABC
Restore to any
server when
needed
•
•
•
•
•
LS XYZ
DB
Self-service restore API
US West
Restores last daily backup
No extra cost, no capacity guarantee
RTO>=24h, RPO=24h
Database URL will change after restore
Automatic
copies of daily
backups
DB
US East
LS OPQ
DB
LS ABC
Failover and
activation of
secondary
(during incident)
•
•
•
•
•
LS XYZ
DB
North Central
US
DB
West US
RTO<2h, RPO<30m
REST and PowerShell API to opt-in and failover
Automatic data replication and synchronization
DMV+REST to monitor and guide failover decisions
Single offline secondary with matching performance level in the DR paired region
East US
North Central US
LS DFE
DB1
Failover and
activation of
secondary
(any time)
LS OPQ
LS XYZ
DB1.old
DB1
DB1
LS ABC
•
•
•
•
•
West US
RTO<1h, RPO<5m
REST and PowerShell API to opt-in and failover
DMV+REST to monitor and guide failover decisions
Automatic data replication and synchronization
Up to 4 online secondary databases with matching
performance level in any region
DB1
East US
South Central US
Audit
log
Azure Storage
SQL Database
Auditing
Application
data
Signup to Auditing Preview
Get started with Auditing in Azure SQL DB
Auditing in Azure SQL Database
Download Excel Template
microsoft.com/sqlserver and Amazon Kindle Store
microsoftvirtualacademy.com
Azure Machine Learning, DocumentDB, and Stream Analytics
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://developer.microsoft.com