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 | 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:
See also: |