Is ok to run a disk defrag using the native windows tool on a local array
that houses SQL databases?It should be fine; but take a full database backup of all databases before
defrag. Stop SQL Server service, otherwise the data files will be locked and
won't be accessible to defrag. DisKeeper will be a good option.
But Physical disk defragmentation quite often is not needed, but
defragmentation within databases (REINDEXING) is good.
Thanks
Hari
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:3336DC2D-0FE2-4513-A002-BD24B4AA018D@.microsoft.com...
> Is ok to run a disk defrag using the native windows tool on a local array
> that houses SQL databases?|||See this article as well..
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
Thanks
Hari
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:udhRWnxpHHA.3312@.TK2MSFTNGP05.phx.gbl...
> It should be fine; but take a full database backup of all databases before
> defrag. Stop SQL Server service, otherwise the data files will be locked
> and
> won't be accessible to defrag. DisKeeper will be a good option.
> But Physical disk defragmentation quite often is not needed, but
> defragmentation within databases (REINDEXING) is good.
> Thanks
> Hari
>
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:3336DC2D-0FE2-4513-A002-BD24B4AA018D@.microsoft.com...
>> Is ok to run a disk defrag using the native windows tool on a local array
>> that houses SQL databases?
>|||Thanks for the info
没有评论:
发表评论