defrag using deskeeper 2007

Is there anything I need to be aware of when I defrag my SQL 2000 server
using deskeeper 2007? Do I need to stop the services or anything else?
Thanks,
IIRC, Diskeeper claims that there server product will defrag sql database
files while sql is still running. I could be misremembering this. I do
have several clients that have done that without any corruptions.
Having said that - stop your sql server. Best not to take the chance, IMHO.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Dooma" <nowhere@.noway.com> wrote in message
news:OW1mw8lnIHA.980@.TK2MSFTNGP06.phx.gbl...
> Is there anything I need to be aware of when I defrag my SQL 2000 server
> using deskeeper 2007? Do I need to stop the services or anything else?
>
> Thanks,
>
>
|||Do you really need to defrag your filesystem?
Linchi
"Dooma" wrote:

> Is there anything I need to be aware of when I defrag my SQL 2000 server
> using deskeeper 2007? Do I need to stop the services or anything else?
>
> Thanks,
>
>
|||Not sure about this poster's need, but I have certainly had client's that
needed to defrag their file system. 300K+ file fragments (which I have seen
at a client) in their database file directory WILL affect performance! :-)
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6A544A98-8CCE-433F-85FE-3718DCD793AE@.microsoft.com...[vbcol=seagreen]
> Do you really need to defrag your filesystem?
> Linchi
> "Dooma" wrote: