AWS Cloud Operations & Migrations Blog

Tag: Singularity

Introducing the AWSSQLServer-DBCC Automation document for SQL Server maintenance

Introducing the AWSSQLServer-DBCC Automation document for SQL Server maintenance

In the first three posts in this five-part series, I introduced you to AWS Launch Wizard Systems Manager Automation documents for SQL Server and showed you how to run the AWSSQLServer-Backup, AWSSQLServer-Restore, and AWSSQLServer-Index Automation documents. In this post, I’ll show you how to use the AWSSQLServer-DBCC document for SQL Server to execute database consistency […]

Read More
Introducing the AWSSQLServer-Index Automation document for SQL Server maintenance

Introducing the AWSSQLServer-Index Automation document for SQL Server maintenance

In the first and second posts in this five-part series, I introduced you to AWS Launch Wizard Systems Manager Automation documents for SQL Server and showed you how to run the AWSSQLServer-Backup and AWSSQLServer-Restore Automation documents. In this post, I’ll show you how to use the AWSSQLServer-Index document for SQL Server index maintenance. The SQL […]

Read More
Introducing the AWSSQLServer-Restore Automation document for SQL Server maintenance

Introducing the AWSSQLServer-Restore Automation document for SQL Server maintenance

In the first post in this five-part series, I introduced you to AWS Launch Wizard Systems Manager Automation documents for SQL Server and showed you how to run the AWSSQLServer-Backup document. In this second post, I’ll show you how to restore a SQL Server backup from Amazon S3 using the AWSSQLServer-Restore document. The SQL Server […]

Read More
Introducing the AWSSQLServer-Backup Automation document for SQL Server maintenance

Introducing the AWSSQLServer-Backup Automation document for SQL Server maintenance

This is the first in a five-part series to introduce you to AWS Launch Wizard Systems Manager Automation documents for SQL Server. AWS maintains these predefined Automation documents, which you can use to perform critical maintenance tasks for SQL Server, including backup, restore, reindex, and DBCC. In this post, I will describe the purpose of […]

Read More
Introducing Maintenance Windows for scheduling Automation documents against your SQL Server instances

Introducing Maintenance Windows for scheduling Automation documents against your SQL Server instances

In parts 1, 2, 3, and 4 of this five-part series, I introduced you to AWS Launch Wizard Systems Manager Automation documents for SQL Server and showed you how to run the AWSSQLServer-Backup, AWSSQLServer-Restore, AWSSQLServer-Index, and AWSSQLServer-DBCC Automation documents. In this last post of the series, I’ll introduce you to Maintenance Windows, a powerful tool […]

Read More