[dba-SQLServer] Defrag machine with SQL 7

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...



More information about the dba-SQLServer mailing list