Skip to Content
author's profile photo Former Member
Former Member

DBCC bringt mehrere Consistency-errors

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2007 at 02:37 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 09:21 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.