Data Backup and Recovery Discussions

Highlighted

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

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!

1 REPLY 1
Highlighted

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

Bump

Check out the KB!
Knowledge Base
All Community Forums