• Question

  • 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


  • 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