EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

On-line Documentation

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

 


See also:

Getting Started

Servers

Policies

Templates

Activities

Options