Online Documentation for SQL Administrator for SQL Server

Database Maintenance


SQL Administrator provides a number of powerful tools that allow you to perform various operations over your servers and databases:

 

In the Maintenance section of the Server Explorer you can view the whole list of actions performed with every database on the selected server as well as their maintenance plans.

 

Note: This section (except for Backup page) is not available for SQL Server Express Edition as managing maintenance plans requires SQL Server Agent service.

 

Maintenance

 

 

To start managing a database you are to select a server in the Server Explorer and then select the Maintenance tab among the sever nodes.

 

The upper work area shows the list of databases vertically and maintenance actions horizontally. For each maintenance action you can see the Last Run Date and Last Scheduled Execution Outcome.

 

The list of actions to perform with the selected database contains the following tasks:

Backup_SQLAdmin Full Backup (a full database backup which backs up the entire database including the transaction log);

Backup_SQLAdmin Differential Backup (a differential backup which records only the changes made to the data in the database after the last full database backup);

Backup_SQLAdmin Transaction Log Backup (a sequence of log backups provided for a continuous chain of transaction information to support recovery forward from database, differential, or file backups);

CheckDatabase Checking Database (a check of the entire database including allocation checks in addition to checks of index structure and data integrity);

RebuildIndexes Rebuilding/Reorganizing Indexes of Database (an operation is performed on indexes of all tables and views);

ShrinkDatabase_SQLAdmin Shrinking Database (shrink the entire database).

 

The toolbar and the context menu of the upper work area allow you to perform the following actions:

CreateMaintenancePlan create maintenance plan

Backup_SQLAdmin backup database

CheckDatabase check database

RebuildIndexes rebuild/reorganize indexes

ShrinkDatabase_SQLAdmin shrink database

Edit edit database

Print create and print the report

 

To get access to the maintenance actions via toolbar you can click the Tasks button and select the necessary task.

 

The toolbar and the context menu of the lower work area allow you to perform the following actions with the maintenance plans:

Edit edit maintenance plan/job

Drop drop maintenance plan/job

MaintenancePlanHistory view maintenance plan/plan history

  • enable/disable maintenance plan/job

StartJob execute maintenance plan/job

  • stop job
  • edit schedules
  • enable/disable schedules

Print create and print the report

 

The lower work area shows information on the maintenance plan/job (Name, Enabled, Last Run Outcome, Last Run Date), schedules (Name, Enabled, Description) and task/job steps (Name, Last Run Outcome, Last Run Duration, Last Run Message) for the selected task.