Microsoft KB Archive/247751

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:13, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


BUG: Database Maintenance Plan Does Not Shrink the Database

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