"Ashwini Khanna" <ashwini400@hotmail.com> wrote in message
news:uplotOW5DHA.2008@TK2MSFTNGP10.phx.gbl...
> I am trying to defrag my Hard-disk drive. Windows 2000 Server does not
> defrag my drice compoletely as major portion is occupied by my SQL
database
> whose size is around 2GB. The Defrag program on completion says that it
> cannot defrag the SQL Database files.
> Then how do I do it? Is there any way to defrag the SQL Database files? I
> need to do it as major portion of my HDD is occupied by database files.

"mountain man" <hobbit@southern_seaweed.com.op> wrote in message
news:5LWRb.32581$Wa.1031@news-server.bigpond.net.au...
> "Ashwini Khanna" <ashwini400@hotmail.com> wrote in message
> news:uplotOW5DHA.2008@TK2MSFTNGP10.phx.gbl...
> > I am trying to defrag my Hard-disk drive. Windows 2000 Server does not
> > defrag my drice compoletely as major portion is occupied by my SQL
> database
> > whose size is around 2GB. The Defrag program on completion says that it
> > cannot defrag the SQL Database files.
> > Then how do I do it? Is there any way to defrag the SQL Database files?
I
> > need to do it as major portion of my HDD is occupied by database files.
>
> In order to reduce space, via enterprise manager you could
> run the "Shrink database" function. Also, you might want to
> look at the housekeeping maintenance functions.
>
>
>
>
>
>