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 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