BUG: Database Maintenance Plan Does Not Shrink the Database

Article ID: 247751 - View products that this article applies to.
This article was previously published under Q247751
BUG #: 56288 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

When you use the Database Maintenance Wizard to create a plan, which includes the option to shrink a database, if the data from any of the tables in that database move from one filegroup to another, the plan does not shrink the database successfully.
Back to the top | Give Feedback

WORKAROUND

Shrink the database by using the DBCC SHRINKDATABASE command.
Back to the top | Give Feedback

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Back to the top | Give Feedback

Properties

Article ID: 247751 - Last Review: October 16, 2002 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbbug kbpending KB247751
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top