Business continuity and database recovery - SQL Server

 Business continuity and database recovery - SQL Server

談論Business continuity and database recovery需考量 RPO與RTO，不同技術可達到的RPO與RTO不同

Recovery Point Objective(RPO): 系統中斷到重啟期間所損失的資料量how much data acceptable to lose 例如: RPO 30分鐘

Recovery Time Objective (RTO): 系統重啟回復正常運作所需花費的時間how much downtime is acceptable by the company, or how quickly must the data be made accessible again. 例如: RTO 60分鐘

Always On AG

Database mirroring

SQL Server Failover Cluster

Log Shipping

Replication

Backup Restore

Business continuity and database recovery - SQL Server

https://learn.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver16