DBCC bringt mehrere Consistency-errors

[Former Member]

Hello experts,

Consistency errors were reported after the dbcc check in the SQL-Server 7.0. Which I think serious are the following tables: ’RESB’, 'DD03L’ and 'CMFP’. How could I fix the database, specially these tables? Could I make this by restoring the SAP database from a backup?

Thank you in advance!

Best regards,

Ying

[Former Member · Accepted solution]

Hi Ying,

the first thing I would do is to find out, why you have these consistency errors. Usually you have some sort of hardware problem (your disks? - contact your hardware vendor). You have to eleminate the root cause of your consistency errors otherwise you will get them again. After you found out what caused the consistency errors you can make a restore from your last consistent backup. Any manual repairs on tables might cause data loss. Since I haven't used SQL Server 7 for years, I am not quiet sure what options DBCC CHECKDB offers with that release. Please also check Books Online.

Regards,

Sven

[Former Member · Accepted solution]

Hi Sven,

Thanks a lot for your answer!

I have done the options, which are suggested in the note 142731. But these tables could not be recovered. I don't know, whether there is any other method except restore a backup of database, which could repair the tables.

Best regards,

Ying

[clas_hortien · Accepted solution]

Hello,

the best recommendation to fix a corrupt database / table is to restore the database from a known good backup. Fixing corruptions by running DBCC with a repair clause will generate logical inconsistencies which will never be able to fix.

When you restore from a backup you know exactly how many work you have lost, when fixing it with DBCC you do not know this.

Database corruptions are caused by hardware problems, so please do an extensive check on all hardware components (DISK, Controller, Memory, CPU ..). Contact your hardware vendor to assists you during these checks.

Regards

Clas

[Former Member]

Hello experts,

thanks a lot for your answers!

I have restored my oldest backup. It was made before 2 weeks. But there were also the inconsistent problems. I have made a homogeneous system copy for that R/3 system (R/3 4.6C), and want to fix the SAP database, specially those three tables, in that copy system. Have you some suggestions? Or is there any other way to fix the database?

BTW, the reason, which caused the database errors, is a hardware error. It had been repaired.

Regards,

Ying