Sunday, March 25, 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