SQL Server Check Database


[FinalBuilder Professional Edition]


The Check Database action will Check allocation and structural integrity of Database objects.

The "Don't Check Indexes" option specifies that nonclustered indexes for nonsystem tables should not be checked. This decreases the overall execution time because it does not check nonclustered indexes for user-defined tables. "Don't Check Indexes" has no effect on system tables, because system table indexes are always checked.


For more information on the sqlmaint tool see: http://msdn.microsoft.com/library/en-us/coprompt/cp_sqlmaint_19ix.asp


To set the location of SQLMaint see SQL Server Options