Amazon EC2 now supports automated recovery of Microsoft SQL Server databases from Volume Shadow Copy Services (VSS) based EBS snapshots. Customers can use an AWS Systems Manager Automation Runbook and specify a restore point of time to automate the recovery process without needing to stop a running Microsoft SQL Server database.
Volume Shadow Copy Services (VSS) allows application data to be backed up while applications are still running. This new feature allows customers to automate the recovery from VSS-based EBS snapshots and ensure rapid recovery of large databases within minutes. This feature also offers customers the flexibility to restore to a new database or achieve point-in-time recovery.
This feature is available in all commercial AWS Regions and the AWS GovCloud (US) Regions.
To learn more, visit this technical document in the Microsoft SQL Server on Amazon EC2 User Guide.
Source:: Amazon AWS