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

Database Integrity Check


Database Integrity Check step allows you to perform the check database operation on the server (the DBCC CHECKDB Transact-SQL statement is issued). This operation is used to check the allocation, structural, and logical integrity of all the objects in the specified database.

 

To launch the database check immediately select Quick_Maintenance_Actions Quick Maintenance Actions | DatabaseIntegrityCheck Database Integrity Check popup menu item in the Servers tab.

 

To perform scheduled database integrity check on regular basis you need to include this task into Policy:

1. At Step 2 of the Create Policy wizard click Create new step button and select Database Integrity Check step type.

2. Also, you can create a new Step Template for further use selecting Database Integrity Check step at the Templates tab.

 

Steps of the Database Integrity Check wizard:

Naming step

Selecting databases

Setting options

Performing operation

 

 


See also:

Backup database

Execute SQL Server Agent job

Execute T-SQL statement

History Cleanup

Database Integrity Check

Shrink Database

Reorganize Indices

Update Statistics

Database Parameters Logger

Maintenance Cleanup

Transaction Log Shipping

Database Shipping

Bulk Restore