BUG: Database Maintenance Plan Does Not Shrink the Database (247751)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q247751
BUG #: 56288 (SQLBUG_70)

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.

WORKAROUND

Shrink the database by using the DBCC SHRINKDATABASE command.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbDSupport KB247751
©2002 Microsoft Corporation. All rights reserved.