Online Documentation for SQL Administrator for SQL Server

Setting repair options


Use this step of the wizard to specify repair error options. This step appears only if !RadioButton Check database(s) now option was selected on the second step. It depends on the checks select on the third step as well.

 

Check Database Wizard - Setting repair options

 

 

!RadioButton No repair data

Selecting this option equals using the REPAIR_FAST argument. This argument enables fast repair of errors which is maintained for backward compatibility.

 

!RadioButton Repair without data loss

Selecting this option equals using the REPAIR_REBUILD argument. This argument performs quick repairs, such as repairing missing rows in non-clustered indexes, and more time-consuming repairs, such as rebuilding an index. These repairs can be performed without risk of data loss.

 

!RadioButton Repair with allowing of data loss

When this argument (REPAIR_ALLOW_DATA_LOSS) is used, all reported errors are repaired. These repairs can cause data loss.

 

Note: It is not recommended to perform any data repairing. Restore from a backup copy instead.

 

Click the Next button to proceed to the Setting check options step of the wizard.