locked
DBCC CHECKDB RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    does  DBCC CHECKDB  actually repair the SQL Database??

    if so, could someone give me code on using the command?

     

     

     I am using the Express version of SQL Server, 2008.

     

     

    Sunday, October 3, 2010 9:59 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Running DBCC CHECKDB without any additional parameters does not repair the database instead it reports consistency errors. Based on those errors one needs to take action. REPAIR_ALLOW_DATA_LOSS, REPAIR_FAST, REPAIR_REBUILD parameters of CHECKDB take care of repairing any consistency errors

    DBCC CHECKDB is explained here



    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    • Proposed as answer by Naomi N Sunday, October 3, 2010 1:57 PM
    • Marked as answer by RockinRon399 Sunday, October 3, 2010 11:15 PM
    Sunday, October 3, 2010 1:14 PM