About consistency checks for SQL
|Article:HOWTO73849|||||Created: 2012-03-02|||||Updated: 2012-03-16|||||Article URL http://www.symantec.com/docs/HOWTO73849|
If you back up a database or transaction log that contains errors, these errors will still exist when the backup is restored. In some cases, this can prevent a successful restore. Backup Exec enables you to check the logical and physical consistency of the data before and after a backup. SQL reports any consistency check failures in the Backup Exec job log. Symantec strongly recommends that you always run a consistency check either before the backup.
Backup Exec's consistency check uses the following SQL consistency check utilities:
Article URL http://www.symantec.com/docs/HOWTO73849