Sunday, February 19, 2012

DB Maint plan not shrinking files - why? Please help

Does anyone know why, when the database maintenance plan runs, that the physical data files are not shrunk to 10% as indicated in the plan? I have a 10 G data file (as part of about 10 data files in this db), 5 G used and 5 G unused, that doesn't seem to
release any of the allocated but unused portion of the file back to the OS. (SQL Server 2000)
because GUI doesnt really work. Try to write a script about it. The same way
a big transaction log wont shrink at all using GUI...
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:2824D45B-FFDE-42D9-BBB7-9EC05F070A3B@.microsoft.com...
> Does anyone know why, when the database maintenance plan runs, that the
physical data files are not shrunk to 10% as indicated in the plan? I have
a 10 G data file (as part of about 10 data files in this db), 5 G used and 5
G unused, that doesn't seem to release any of the allocated but unused
portion of the file back to the OS. (SQL Server 2000)
|||in BOL look at DBCC SHRINKDATABASE
You could use a job instead of MP !
"Stephanie" wrote:

> Does anyone know why, when the database maintenance plan runs, that the physical data files are not shrunk to 10% as indicated in the plan? I have a 10 G data file (as part of about 10 data files in this db), 5 G used and 5 G unused, that doesn't seem
to release any of the allocated but unused portion of the file back to the OS. (SQL Server 2000)

No comments:

Post a Comment