Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Unable to defrag a disk volume with an instance of MSSQL running

Avatar of garychu
garychu asked on
Microsoft SQL ServerWindows Server 2003
14 Comments1 Solution1101 ViewsLast Modified:
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