Sunday, March 11, 2012

Defrag local drive in SQL Server 2005

Are there any considerations that must be taken before defragging the local
drives in SQL Server 2005? For RAID and non-RAID drives?A backup would be nice first but other than that not really.
--
Andrew J. Kelly SQL MVP
"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:A0DD0845-0609-4094-9A23-3DAEF22922B3@.microsoft.com...
> Are there any considerations that must be taken before defragging the
> local
> drives in SQL Server 2005? For RAID and non-RAID drives?|||Thanks...
"Andrew J. Kelly" wrote:
> A backup would be nice first but other than that not really.
> --
> Andrew J. Kelly SQL MVP
> "morphius" <morphius@.discussions.microsoft.com> wrote in message
> news:A0DD0845-0609-4094-9A23-3DAEF22922B3@.microsoft.com...
> > Are there any considerations that must be taken before defragging the
> > local
> > drives in SQL Server 2005? For RAID and non-RAID drives?
>
>|||morphius wrote:
> Are there any considerations that must be taken before defragging the local
> drives in SQL Server 2005? For RAID and non-RAID drives?
Be sure to shut down SQL Server, otherwise the data files will be locked
and won't be accessible to defrag. DisKeeper claims to defrag database
files without shutting down SQL, but I wouldn't be comfortable doing that.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment