BUG: Database Maintenance Plan Does Not Shrink the Database

This article was previously published under Q247751
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56288 (SQLBUG_70)
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.
Shrink the database by using the DBCC SHRINKDATABASE command.
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Article ID: 247751 - Last Review: 10/26/2013 05:24:00 - Revision: 2.0

  • Microsoft SQL Server 7.0 Standard Edition
  • kbnosurvey kbarchive kbbug kbDSupport KB247751