Online Documentation for SQL Backup for SQL Server

Maintenance steps

Step in EMS SQL Backup is a basic component of server maintenance. It sets the maintenance action to be performed over the database(s) and is used in Tasks and Policies.


Steps can be run separately for a single database\server for performing immediate maintenance operation. Steps can be included into Polices for scheduled performing.


Creating Steps

Editing Existing Steps


Note: To run the immediate maintenance action use the Quick_Maintenance_Actions Quick Maintenance Action item from the database\server popup menu.


Backup Database

Restore Database

Execute SQL Server Agent job

Executing T-SQL statement

History Cleanup

Database Integrity Check

Reorganize Indices

Shrink Database

Update Statistics

Database Parameters Logger

Maintenance Cleanup

Transaction Log Shipping

Bulk Restore