Use an automation runbook to restore your database from AWS VSS solution snapshots
This guide explains how to use the AWSEC2-RestoreSqlServerDatabaseWithVss
automation runbook to restore a Microsoft SQL Server database running on an EC2 instance from
application-consistent snapshots created by the AWS VSS solution. You can tailor the restoration
parameters to your specific needs, such as setting the database to restore mode after restoration.
By leveraging Windows VSS technology, this solution offers the following advantages:
-
Fast restoration times.
-
The ability to perform the restore without shutting down or pausing the Microsoft SQL Server application.
For more information about the AWS VSS solution, see Application consistent Windows VSS based Amazon EBS snapshots in the Amazon EC2 User Guide.
Contents
Pricing
The AWS VSS solution uses AWS Systems Manager automation runbooks with EBS resources to restore a Microsoft SQL Server database on an EC2 instance. Associated costs include the following:
- Systems Manager Automation
-
With Systems Manager automation runbooks, you pay only for what you use and are charged based on the number and duration of steps, which includes a free tier per account. If you created an organization, your free tier usage is shared across all accounts in the Consolidated Billing family. For more information about Systems Manager automation pricing, see Automation
. - Amazon EBS
-
During restore steps, the AWS VSS solution creates a new EBS volume and restores data from VSS based EBS snapshots. With Amazon EBS resources, you pay only for what you provision. For more information, see Amazon EBS pricing
.
