Defragging SQL Database

[Ashwini Khanna]

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

 

[George Hester]

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

 

[Ashwini Khanna]

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

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

 

[George Hester]

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.

 

[Bob I]

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

 

[George Hester]

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.

 

[Ashwini Khanna]

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


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.

 

[Bob I]

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