"Ashwini Khanna" <ashwini400@hotmail.com> wrote in message
news:ejtQNOW5DHA.2720@TK2MSFTNGP09.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.
>
> Regards,
> Ashwini
>
>

> Stop the SQL Server - I guess OS can't defrag open files.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
> "Ashwini Khanna" <ashwini400@hotmail.com> wrote in message
> news:ejtQNOW5DHA.2720@TK2MSFTNGP09.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.
> >
> > Regards,
> > Ashwini
> >
> >
>
>

>
> I have done that.Even that is not working.
>
> "Dejan Sarka"
> <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote
> in message news:#e1T6rY5DHA.2720@TK2MSFTNGP09.phx.gbl...
> > Stop the SQL Server - I guess OS can't defrag open
> files. >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> > "Ashwini Khanna" <ashwini400@hotmail.com> wrote in
> > message news:ejtQNOW5DHA.2720@TK2MSFTNGP09.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. >
> > > Regards,
> > > Ashwini
> > >
> > >
> >
> >
>