Article ID: 247751 - Last Review: October 16, 2002 - Revision: 1.1

BUG: Database Maintenance Plan Does Not Shrink the Database

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

WORKAROUND

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

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Back to the top
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Back to the top
Keywords: 
kbbug kbpending KB247751
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

 

Related Support Centers