Sunday, March 11, 2012

Defrag Sql Drives?

Is it OK to defrag drives with sql data/logs using the built in defrag in
W2K Server? Logs and data live on two separate hardware raid drives in the
same server.
MIt is usually not recommended while SQL Server is running but otherwise it
should be OK. Always do a full backup first.
Andrew J. Kelly SQL MVP
"Maureen" <nosend2me@.hotmail.com> wrote in message
news:#PCzkZSFEHA.1512@.TK2MSFTNGP11.phx.gbl...
> Is it OK to defrag drives with sql data/logs using the built in defrag in
> W2K Server? Logs and data live on two separate hardware raid drives in the
> same server.
> M
>
>

No comments:

Post a Comment