Francisco Tapia
fhtapia at gmail.com
Wed Oct 4 15:44:45 CDT 2006
Sql Server Files are IN USE while Sql Server is running, in order to defrag these files stop the SQL Server instance then defrag, and resume the engine once your defrag process has completed. On 10/4/06, Mark A Matte <markamatte at hotmail.com> wrote: > Hello All, > > I am running SQL7 on an XP Pro machine. I tried to defrag but it tells me > it cannot defrag the SQL server files. I used the 'shrink database' feature > as an attempt. It did recover some space...but I still cannot defrag. Is > there a way around this? > > Thanks, > > Mark A. Matte > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More...