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