Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suggestion on sp_iqcheckdb 'allocation database'

Hi

usually sp_iqcheckdb 'allocation database'  takes few minute (10 minute)  and  IQ DB size is 15 TB without any error ..

today i got dbcc reported error in output . I suspect while running sp_iqcheckdb  there was some application batch job was also running .

Could you please suggest what should i do  for following error ...

DBCC Allocation Mode Report

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

** DBCC Status                                    Leaked block checking skipped due to errors

** DBCC Status                                    Errors Detected

** DBCC Locked Table Access Conflict              1

** DBCC Future Version Errors                     75

Should i run in off-business hour again or  should i run dbcc with 'drop leakage' .

Regards

Ajay Pandey

Former Member
Not what you were looking for? View more on this topic or Ask a question