DBCC CHECKDB

  • Comments posted to this topic are about the item DBCC CHECKDB

  • Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Nice question. I have to read BOL to identify correct answer...

    Thanks

  • Nice Question - made me read up in BOL and actually learn something useful.

    Thanks

  • Nice one. Got it by a process of elimination rather than actual knowing the incorrect one!

  • Nice question, thanks.

  • Nice question.

    Surprising that fewer than half of people got it right so far (140 out of 306) as the three true options are rather obviously true. But at least the correct answer is the most popular one.

    Tom

  • Nice easy question.... I misread it....

    I read the BLOB one as that it does check BLOBs.... and went... wait I think it does all of these...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Great question, thanks! I'm with Gazareth on this one; it was just process of elimination for me.



    Everything is awesome!

  • This was removed by the editor as SPAM

  • I take issue with this option:

    DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option.

    This is not always true (it depends on exactly where the corruption is), and when it is, it is true only for very weak definitions of "repair", as the end result is not your database as it was before the corruption occurred but instead a possibly valid but most likely inconsistent database file.

    EDIT: BBCode/IFCode, NOT HTML. :blush:

  • Thanks for the question. Almost got it wrong due to speed reading wording about link-level consistency of BLOBS in the FILE SYSTEM. As others have mentioned, I knew I had to recheck that, due to eliminating the other three answers.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • sknox (5/17/2012)


    I take issue with this option:

    DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option.

    This is not always true (it depends on exactly where the corruption is), and when it is, it is true only for very weak definitions of "repair", as the end result is not your database as it was before the corruption occurred but instead a possibly valid but most likely inconsistent database file.

    EDIT: BBCode/IFCode, NOT HTML. :blush:

    From the BOL ref: "These repairs can cause some data loss."

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • good questions - cheers

  • Followup question: What class of command is DBCC CHECKDB ? It doesn't seem to fall into the category of DML, DDL, DCL or TCL.

    Thoughts?

    Andre

Viewing 15 posts - 1 through 15 (of 25 total)

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