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

Defrag the drive from a different operating system on a different partition.

--
George Hester
__________________________________
"Ashwini Khanna" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>
>

Ya thats a very good idea. But we dont have a dual boot system. its a
company Server!
any other suggestion ?

"George Hester" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
Defrag the drive from a different operating system on a different partition.

--
George Hester
__________________________________
"Ashwini Khanna" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

Nope unless you purchase a defrag which works at boot. Diskkeeper does that and others I suppose. I believe Norton's product doesn't require this but it is no longer supported. The fact is though that completely defragging the SQL databases will likely do nothing more for you than what you have now.

--
George Hester
__________________________________
"Ashwini Khanna" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Ya thats a very good idea. But we dont have a dual boot system. its a
> company Server!
> any other suggestion ?
>
> "George Hester" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> Defrag the drive from a different operating system on a different partition.
>
> --
> George Hester
> __________________________________
> "Ashwini Khanna" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> >
>
>

How about move database to a different drive, defrag the drive, and then
move the datbase file back. No more gaps.

Ashwini Khanna wrote:

> 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
>
>
>

Ah that's right. The ole' defrag the pagefile.sys solution. Almost forgot about all that - actually did. Haven't done that since Windows NT 4.

--
George Hester
__________________________________
"Bob I" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> How about move database to a different drive, defrag the drive, and then
> move the datbase file back. No more gaps.
>
> Ashwini Khanna wrote:
>
> > 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
> >
> >
> >
>

Hey! That generates one more question.... whats this file pagefile.sys?
What does it do? I have it on my C:\


"George Hester" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
Ah that's right. The ole' defrag the pagefile.sys solution. Almost forgot
about all that - actually did. Haven't done that since Windows NT 4.

--
George Hester
__________________________________
"Bob I" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How about move database to a different drive, defrag the drive, and then
> move the datbase file back. No more gaps.
>
> Ashwini Khanna wrote:
>
> > 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
> >
> >
> >
>

Try Start, Help, "Virtual Memory" and all will be revealed. :-)

Ashwini Khanna wrote:

> Hey! That generates one more question.... whats this file pagefile.sys?
> What does it do? I have it on my C:\
>
>
> "George Hester" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> Ah that's right. The ole' defrag the pagefile.sys solution. Almost forgot
> about all that - actually did. Haven't done that since Windows NT 4.
>
> --
> George Hester
> __________________________________
> "Bob I" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>How about move database to a different drive, defrag the drive, and then
>>move the datbase file back. No more gaps.
>>
>>Ashwini Khanna wrote:
>>
>>
>>>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
>>>
>>>
>>>
>>>
>
>