I have tried unsuccessfully to defrag the hard disk on which there is an instance of a MSSQL 2000 SP3 server.
Operating system is Windows 2003 Std Server SP2
MSSQL is installed on a separate disk volume from the OS. The MSSQL volume is a bunch of 4x72GB SCSI hard disks configured as RAID 5.
Repeated attempts at defragging (using the OS defrag) returns message that the <database>.ldb file could not be defragged.
The defrag attempts were always with the MSSQLSERVER and SQLSERVERAGENT services first stopped.Additionally, I have tried taking offline the <database> before-hand. And even detaching the <database>. But each time, the defrag fails.
what could be the reason?
Any assistance to resolve this issue would be appreciated. Thanks