August 16, 2007 at 1:01 pm
I have one db that
when ever I run DBCC Checkdb I get the following:
"Msg 0
, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded."
I have searched
EVERYWHERE and the only thing that seems to work is to do the following prior to running checkdb:
backup
log audit with truncate_only
dbcc
shrinkfile('audit_log', 'truncateonly')
I run checkdb
and it works fine. But after a couple of days I try running checkdb again and I get the same error message! So what is causing this??!!
Thanks
!
August 17, 2007 at 3:14 am
Hi,
Did you checked out the Eventlog and the SQL error log? If you find any entities in the App log, do post it.
It would be helpful to narrow down the issue.
Regards
Kumar
August 17, 2007 at 6:59 am
dbcc checkdb needs free space in TEMPDB. Try DBCC CHECKDB WITH ESTIMATEONLY to see how much tempdb space is needed and make sure you can get it. Also, if you have an quiet/inactive time on the database you could try DBBC CHECKDB WITH TABLOCK, as BOL says this option stops the need for the command to scan the database transaction log.
August 17, 2007 at 10:58 am
Your not backing up transaction logs. Not sure why, but you apparently don't need them. Just change the DB to "Simple" recovery. As for the error, you are probably running out of space. Check the logs.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply