Post reply

DBCC CHECKDB lock the Databases

  • July 27, 2017 at 1:06 am

    #338492

    How to check this task, Is this coming by default sql server ? and how to stop this task

  • July 27, 2017 at 1:30 am

    #1952950

    Have a look to see if it's a SQL Agent job or possibly a Maintenance Plan has been created.

    Thanks

  • July 27, 2017 at 1:38 am

    #1952951

    NorthernSoul - Thursday, July 27, 2017 1:30 AM

    Have a look to see if it's a SQL Agent job or possibly a Maintenance Plan has been created.

    Thanks

    ok, I found it thanks. But its run on Monday and Thursday every week. How often should I run this

  • July 27, 2017 at 1:49 am

    #1952954

    Weekly would be good. Often enought that if you find corruption, you can fix it by restoring from backup and lose no data in the process.

    It doesn't lock the database, it doesn't take any locks at all.

    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

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

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