[dba-SQLServer] Defrag machine with SQL 7

I had tried that but no luck...then I rebooted...without starting SQL and it 
worked fine...guess even after I stopped SQL the files were still being 
called by something...or stuck in memory.

Thanks,

Mark A. Matte


>From: "Francisco Tapia" <fhtapia at gmail.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Defrag machine with SQL 7
>Date: Wed, 4 Oct 2006 13:44:45 -0700
>
>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...
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>