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 Content Component encountered an error
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.