Use an automation runbook to restore your database from Amazon VSS solution snapshots - Microsoft SQL Server on Amazon EC2
Pricing
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Use an automation runbook to restore your database from Amazon 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 Amazon 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 Amazon VSS solution, see Application consistent Windows VSS based Amazon EBS snapshots in the Amazon EC2 User Guide.

Contents

Pricing

The Amazon VSS solution uses Amazon 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 Amazon 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.