2013-12-31 06:29 AM - edited 2015-12-18 01:11 AM
Backup verification report has been finding consistency error in one database for the past week:
[01:39:47.871] [PRESQL01] Attaching database [AppFabricMonitoring__Clone]...
[01:39:47.871] [PRESQL01] CREATE DATABASE [AppFabricMonitoring__Clone] ON PRIMARY (NAME = 'AppFabricMonitoring', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk008\AppFabricMonito
[01:39:50.235] [PRESQL01] Database attached.
[01:39:50.237] [PRESQL01] ALTER DATABASE [AppFabricMonitoring__Clone] SET AUTO_SHRINK OFF
[01:39:50.257] [PRESQL01] DBCC CHECKDB (N'AppFabricMonitoring__Clone') WITH NO_INFOMSGS, TABLOCK, PHYSICAL_ONLY
[01:40:36.266] [PRESQL01] Table error: page (1:396), whose header indicates that it is allocated to object ID 1429580131, index ID 9, partition ID 72057594049855488, alloc unit ID 72057594056671232 (type In-row data), is allocated by another object.
Table error: page (1:4630), whose header indicates that it is allocated to object ID 1429580131, index ID 9, partition ID 72057594049855488, alloc unit ID 72057594056671232 (type In-row data), is allocated by another object.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'ASStagingTable' (object ID 1429580131).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'AppFabricMonitoring__Clone'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (AppFabricMonitoring__Clone).
[01:40:36.365] [PRESQL01] WARNING: SQLServer DBCC CHECKDB failed.
[01:40:36.501] [PRESQL01] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409e6
[01:40:36.501] [PRESQL01] Detaching database [AppFabricMonitoring__Clone].
[01:40:36.866] [PRESQL01] Database was detached successfully.
[01:40:36.867] [PRESQL01] Checking clone database name...
These errors started 12-18 and occurred during every daily backup verification except on 12-19 and 12-26. When I run DBCC CHECKDB on the live database, it finds no errors. Why would there be errors on most of the backups but not on the live database? What can I do to fix this?