hi anoop.mig29

repair_rebuild, indicate that case find any error, this should be repaired, no data loss!

allow_repair_data_loss, allow the possible data loss, if find any error!

follow micrisoft's documentation: http://technet.microsoft.com/en-us/library/ms176064(v=sql.105).aspx