Q

Can I use the Win2k defrag tool on a server hosting 250+ GB of database info?

Can I use the Windows 2000 defragmentation tool on a server hosting large amounts (250+ gigabytes) of Microsoft SQL Server 2000 databases? If I can't, what should I use?
You can, but I would not recommend it. Since the Windows 2000 defragger is a basic manual defragger, it does not offer the best performance possible to accomplish such a task. You should choose a third-party product that can do a much more lean and mean job. Also, please do not forget to shut down the SQL Server before running the defragger. Also, do a backup beforehand, just to be sure.
This was first published in December 2002

Dig deeper on Microsoft Windows 2000 Server Administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close