Post reply

dbcc physical_only WITH (STATE =online)

  • June 22, 2010 at 12:00 pm

    #224126

    I want to run a DBCC check on a very large table but I want to keep the DB online at the same time.

    Is this a valid option or not?

    DBCC physical_only WITH (STATE =online)

  • June 22, 2010 at 12:12 pm

    #1183530

    That's not a valid option, and it's not a valid DBCC command either.

    CheckDB checks are by default online, there's nothing you need to add to ensure that. They can slow things down, but they won't take the DB offline.

    DBCC CHECKTABLE (<Table Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

  • June 22, 2010 at 2:54 pm

    #1183601

    Thanks for the reply but I had a blonde moment there. I combined two different questions I was going to ask. I'll re-write them later from home.

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

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