Tuesday, March 27, 2012

dbcc shrink taking forever

Im trying to shrink a data file with 5 gigs free. Nobody is in the db but Im
40 minutes down the road with not light at the end of the tunnel. Is there a
faster way?That's not an unreasonable amount of time for it to take depending on your
hardware and the fragmentation level of the free space in the database. I
would give it a couple of hours at least. In SQL Server 2005 shrink has
progress reporting which will help with this type of problem.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"chris" <chris@.noemail.com> wrote in message
news:#y5fNrtLEHA.2716@.tk2msftngp13.phx.gbl...
> Im trying to shrink a data file with 5 gigs free. Nobody is in the db but
Im
> 40 minutes down the road with not light at the end of the tunnel. Is there
a
> faster way?
>

No comments:

Post a Comment