Question:
Hi all,
I ran a DBCC CHECKDB (<SID>) WITH NO_INFOMSGS on a 46C, NT/SQL2000 system. When it finished the following messages where returned:
CHECKDB found 1 allocation errors and 0 consistency errors in table '(object id 845374597)'
The minimum repar level for this is repair_allow_data_loss.
Can someone please advise as to appropriate actions to take to resolve this, without dataloss.
Thanks in advance.
Paul M
Answer:
Hi
Attention you should not perform this procedure if you are not experienced in MSSQL.
First of all stop the SAP system and create full database backup if possible.
Then you have to find out the corrupt table related to the object number.
when it is found you can try exporting the data from the table but there is a chance that there will be some missing data that you can maybe recover by restoring healthy backup to another machine.
Now you can do one of two things.
Start the sap system and delete all data from the table using SE14 then stop the system and reload the exported data from the file.
or
if the table is not a system table you can delete the table from the sqlserver directly and start the SAP system, you can then go to db02 and do DDIC-ABAP consistency check and then create the table when the inconsistency is found and reload it from the file.
Just make sure you have valid DB backup before you begin!!!!
Good luck