Post reply

CheckDB appearing in logs quite often

  • June 26, 2006 at 9:18 am

    #61279

    Hi,

    I have this log appearing every 1 - 4 hours in my logs

    "DBCC CHECKDB (cvm, repair_fast) executed by NT AUTHORITY\SYSTEM found 0 errors and repaired 0 errors."

    Now i know what checkdb is but i dont know why its appearing so often, it doesnt appear to be scheduled and is not part of the maintenance jobs.

    Im using sqlserver 2000.

  • June 26, 2006 at 10:12 am

    #645875

    Hmm. Spooky. Clearly it's coming from somewhere - I'd try running a profiler trace, filtering on DBCC commands only, and including the Host_Name column. This might give you a clue as to the source of the command.

  • June 27, 2006 at 12:41 am

    #645976

    "NT AUTHORITY\SYSTEM" gives me kind of clue that there might be some application/service running this.

    I agree with Philiip about profiler and DBCC filter.

    1. Do you have some application which monitors sql server?

    2. Do you see some regular kind of trend when the checkdb is running (daily night or every hour etc.) if yes, run profiler during that time.

  • June 27, 2006 at 2:06 am

    #645991

    Thanks for your help guys, Someone had checked the "Verify database after backup" option in the maintenance plan. resolved now.

    Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply