Windows Defrag on a SQL box

[nunzeo]

Can you run windows defrag on a volume that houses a SQL DB? Do you have to shut down SQL services first before defragging if it is possible?

Thanks.

 

[ptheriault]

If it is possible you should shut down the instance.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[JayKusch]

I have had pretty good luck with the latest versions of DisKeeper. You are able to customize the jobs on many levels in order to aleviate any performance issues on the DB while it is active.

Thanks

J. Kusch

 

[mrdenny]

A properly setup disk drive for a SQL Database shouldn't have any fragmentation on it. After you defrag the drive you'll want to remove what ever files are causing the fragmentation on the disk.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[nunzeo]

mrdenny,

that is true. but the person who built this server built one raid 5 volume. so the DB does not exist on its on partition.