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

Question

The MSDN article on the DBCC CHECKDB command explains three ways to perform database repairs in the syntax section:

- REPAIR_ALLOW_DATA_LOSS - REPAIR_FAST - REPAIR_REBUILD 

But I found the following expression when I was looking for how to restore a suspicious database, and I cannot figure out which of the three modes it is:

DBCC CHECKDB (database name, repair )

I followed the instructions and it works great. I am confused because there is no reference to the repair option on my own without ending with the word _allow_data_loss, _fast, or _rebuild.

Thanks in advance,

Answer 1

The task is only “repair”, since the second parameter in DBCC CHECKDB will be the same as “repair_allow_data_loss”. I just ran this on a local instance and SQL logs confirm this.