Online Documentation for SQL Backup for SQL Server

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