[dba-SQLServer] Shrink file - Reorganize pages before releasing unused space

Mark Rider ridermark at gmail.com
Thu Nov 29 13:02:14 CST 2007


In my experience with this the disk space does not show a difference until
the process is well underway, and sometimes not until it is complete.

As to how it does what it does, I will leave that to the Gurus on the list!



On Nov 29, 2007 12:45 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:

> Does anyone know if this process is done "in place", i.e. if it is similar
> to a defrag on a hard disk where the existing file is used and data inside
> of the file is simply moved around?  Or is the data in the file copied out
> into a new file?  I started this running and wile it claims to be working
> (the little "executing" ring is going round) I do not see any indication
> that the available disk space on any system drive is changing.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Mark Rider
http://dfwmdug.org

Don't anthropomorphize computers.
They don't like it.



More information about the dba-SQLServer mailing list