Check DB Failure in ECC 6.0

[Former Member]

Dear All,

Check database consistency failed in DB13 for the below system. We got the same error in DEV, QAS, PRD.

SAP: Ecc6.0 - Non Unicode

OS : Windows 2003 server R2 SP2

DB : MSSQL 2005 (4035)

error

====================================================================

Error - when run the

DBCC CHECKDB WITH NO_INFOMSGS

GO

=====================================================================

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (1:1402702) in object ID 1980676437, index ID 1, partition ID 411280587685888, alloc unit ID 71905924672192512 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (3:1717880) in object ID 1980676437, index ID 1, partition ID 411280587685888, alloc unit ID 71905924672192512 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (4:1442398) in object ID 1980676437, index ID 1, partition ID 411280587685888, alloc unit ID 71905924672192512 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (4:1442402) in object ID 1980676437, index ID 1, partition ID 411280587685888, alloc unit ID 71905924672192512 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

Msg 8914, Level 16, State 1, Line 1

Incorrect PFS free space information for page (4:1442407) in object ID 1980676437, index ID 1, partition ID 411280587685888, alloc unit ID 71905924672192512 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

CHECKDB found 0 allocation errors and 5 consistency errors in table 'acc.VBDATA' (object ID 1980676437).

CHECKDB found 0 allocation errors and 5 consistency errors in database 'ACC'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ACC).

Please suggest me

Regards

Raj

[sunny_pahuja2]

Hi,

Check SAP Note 1006920 - DBCC Checks show 8914 Errors on SQL Server 2005

Thanks

Sunny

[Former Member]

Hello Sunny,

We are working on the option "REPAIR_ALLOW_DATA_LOSS" . i would like to know will be there any major impact or any negative impact. since this is PRD system , the customer is reluctant for the data loss. Please suggest.

Regards

Raj

[Former Member]

Dear Sunny,

The issue is resolved. We had run the report with SAP support. Thanks for your help

Regards

Raj

[yuktesh_b]

Hi Raj,

Did you lose any data if you select "REPAIR_ALLOW_DATA_LOSS" ? We also have the same problem in the Production environment.

Regards,

Yuktesh