Subscribe

SQL Server Verification DBCC CheckDB finding errors on backup that do not exist on live database

[ Edited ]

Hi

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\AppFabricMonitoring.mdf') LOG ON (NAME = 'AppFabricMonitoring_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk009\AppFabricMonitoring_log.ldf') FOR ATTACH

[01:39:50.235]  [PRESQL01] Database attached.

[01:39:50.236]  [PRESQL01]

[01:39:50.237]  [PRESQL01] ALTER DATABASE [AppFabricMonitoring__Clone] SET AUTO_SHRINK OFF

[01:39:50.256]  [PRESQL01]

[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?

Thank you!

Re: SQL Server Verification DBCC CheckDB finding errors on backup that do not exist on live database

Bump