Article ID: 247181
Article Last Modified on 3/14/2006
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q247181
BUG #: 54421 (SQLBUG_70)
SYMPTOMS
The Maintenance Plan executes "dbcc checkdb(dbname, REPAIR_FAST) WITH NO_INFOMSGS" if the -CkDBRepair option is specified on the SQLMaint command line.
SQLMaint incorrectly reports the status of the task as successful even though the CHECKDB was never able to run the REPAIR_FAST option.
CAUSE
For the REPAIR_FAST option to work, the DB needs to be in single user mode. SQLMaint does not put the database in single user mode before running the CHECKDB. Nor does SQLMaint return an error when the DBCC command fails to execute.
WORKAROUND
Add a step in the job to place the database in single user mode before the job runs. SQL Database Maintainance Plans automatically generate jobs. This particular job will be named with the name of the maintainance plan followed by 'DB Maintenance Plan check Integrity'. Edit the job and insert a step to place the database into single user mode before the step that executes the xp_sqlmaint commands.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
MORE INFORMATION
REPAIR_FAST performs minor, nontime-consuming repair actions such as repairing extra keys in nonclustered indexes. These repairs can be done quickly and without risk of data loss.
Additional query words: repair_fast
Keywords: kbbug kbfix KB247181
