Search code examples
sql-servert-sqldbcc

Which type of repair level is "DBCC CHECKDB (databasename, repair)"?

The MSDN's article about the command "DBCC CHECKDB" explains three ways to perform a database repair in the syntax section: 

- REPAIR_ALLOW_DATA_LOSS
- REPAIR_FAST
- REPAIR_REBUILD

But I found the following statement when I was looking for how to repair a suspect database and I can't understand which one of the three modes is it:

DBCC CHECKDB (databaseName, repair)

I executed the statement and it works fine. I'm confused because there isn't any reference to the "repair" parameter alone without finish the word with "_allow_data_loss", "_fast" or "_rebuild".

Thanks in advance,

Solution

  • Specifying only "repair" as the second parameter in DBCC CHECKDB will be the same as "repair_allow_data_loss". I just ran this on a local instance, and the SQL logs confirm this.