Sunday, March 11, 2012

Defrag needed ?

Hi,
Env : SQLserver2000 Entr. (active/passive cluster)
windows 2000 adv. server.
Server has RAID10 setup for all the drives. I have used
one partition X for the backups and i used to delete the
older backups. right now i want to use this partition for
the database files because i changed my backups to
different drive. Before placing the database files to
this drive X, Do i need to run any defrag utility? or
windows defrag? . If i wont run anything and use this X
drive for my database files , will it hurt SQL
Performance?
ThanksIf there is nothing on the partition it shouldn't matter. The OS wont care
if there was something there before as long as it's deleted for good you
should be all set.
--
Andrew J. Kelly
SQL Server MVP
"kris" <kpxus@.yahoo.com> wrote in message
news:032f01c36b40$6b042aa0$a401280a@.phx.gbl...
> Hi,
> Env : SQLserver2000 Entr. (active/passive cluster)
> windows 2000 adv. server.
> Server has RAID10 setup for all the drives. I have used
> one partition X for the backups and i used to delete the
> older backups. right now i want to use this partition for
> the database files because i changed my backups to
> different drive. Before placing the database files to
> this drive X, Do i need to run any defrag utility? or
> windows defrag? . If i wont run anything and use this X
> drive for my database files , will it hurt SQL
> Performance?
> Thanks
>

No comments:

Post a Comment