Article ID: 247751
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
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.
Additional query words: SHRINKDATABASE
Keywords: kbbug kbpending KB247751