|
Home > Archive > MS SQL Server > August 2005 > shrink database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi,
After perform shrinking database, the database size would reduce as
expected. However, I performed shrink database from enterprise manager for a
small database, the database size increase from 513MB to 631MB. What's the
issue to cause this increase?
--
Best Regards,
Lynn
| |
|
| Shrinking a db with blobs can do that. Here is kb on such issue.
http://support.microsoft.com/kb/324432
--
-oj
"Lynn" <Lynn@discussions.microsoft.com> wrote in message
news:9C9EF0E7-C3A0-412E-9EFA- 9FD44FD8D2C5@microso
ft.com...
> Hi,
>
> After perform shrinking database, the database size would reduce as
> expected. However, I performed shrink database from enterprise manager
> for a
> small database, the database size increase from 513MB to 631MB. What's
> the
> issue to cause this increase?
>
> --
> Best Regards,
>
> Lynn
| |
| Paul S Randal [MS] 2005-08-12, 1:23 pm |
|
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"oj" <nospam_ojngo@home.com> wrote in message
news:%23achJ2snFHA.3568@TK2MSFTNGP10.phx.gbl...
> Shrinking a db with blobs can do that. Here is kb on such issue.
> http://support.microsoft.com/kb/324432
>
>
>
> --
> -oj
>
>
> "Lynn" <Lynn@discussions.microsoft.com> wrote in message
> news:9C9EF0E7-C3A0-412E-9EFA- 9FD44FD8D2C5@microso
ft.com...
>
>
|
|
|
|
|