Ask the Expert

Is it safe to run disk defragmentation on SQL 2000 & Exchange 2000 servers?

Is it safe to run disk defragmentation on SQL 2000 & Exchange 2000 servers? One of my clients is running a Prophit 21 application that runs on SQL 2000, and they told him not to run any type of disk defragmentation.

Requires Free Membership to View

Usually, it is safe to defrag SQL and Exchange Servers. Both are using database files, which are locked while the system is running. So a defragger will skip these files and proceed with the next ones. If you want to defrag these files, you have do use an offline defragger, which is included in most comercial ones. This tool also adds automatically locked files to a list of files to be defragged at next system startup. So you don't have to worry about it at all. :)

However, there are some applications which rely on certain files to be at certain locations. This is a copy protection, which I think is very uncomfortable and nowadays out-of-date. But when you run those apps, you will get trouble if a defragger moves these files. Please check the manual if there is a statement about such a behavior. If this is true, exclude the files from defragmentation. Most of the commercial defraggers do offers such an option.

This was first published in June 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: