• Ratheesh.K.Nair (1/29/2013)


    DBCC CHECKDB WITH TABLOCK GAVE BELOW ERROR

    ---------------------------------------------------------------

    Msg 5030, Level 16, State 12, Line 1

    The database could not be exclusively locked to perform the operation.

    Msg 7926, Level 16, State 1, Line 1

    Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.

    Make sure there are no users in the database and try again. Tablock requires exclusive locks.

    Definitely looking like it's not a checkDB problem. Did you read the blog post I referenced?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass