[dba-SQLServer] Defrag machine with SQL 7

when the service is stopped / sql server / sql server agent, these
files are released, if they are not there may be a problem w/ the way
your OS is handeling this, addtionally if you are running an A/V you
may wish to not scan the mdf/ldf files so that they are released.
otherwise what will happen is that it takes forever for some a/v
software to release the files.

On 10/5/06, Mark A Matte <markamatte at hotmail.com> wrote:
> 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
> >
>
>
> _______________________________________________
> 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...