About consistency checks for SQL

Article:HOWTO24065  |  Created: 2010-01-01  |  Updated: 2011-06-15  |  Article URL http://www.symantec.com/docs/HOWTO24065
Article Type
How To

Product(s)

Subject


About consistency checks for SQL

If you back up a database, transaction log, or filegroup 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 or after the backup.

Backup Exec's consistency check uses the following SQL consistency check utilities:

  • CHECKDB

  • CHECKCATALOG

  • CHECKFILEGROUP

  • PHYSICAL_ONLY

CHECKDB, CHECKCATALOG, and PHYSICAL_ONLY are performed for database-related operations.

CHECKFILEGROUP is performed for filegroup-related operations.

For more information concerning these utilities, see your MS SQL documentation.

See Setting backup options for SQL


Legacy ID



id-SF700189097_be2010_adm


Article URL http://www.symantec.com/docs/HOWTO24065


Terms of use for this information are found in Legal Notices