UltraDefrag - How to run as scheduled task! (REVISED)

Recently I have tested successfully a free and open license defrag tool that not only successfully defragged over abused SQL, DCs and Exchange servers but actually solved my error on unsuccessful backups due to DBCC errors on live SQL servers!

This excellent tool is UltraDefrag!

Official site: http://ultradefrag.sourceforge.net/en/index.html

Our servers having tested the old failed version of Diskeeper 2010, been defragges and optimized overnight successfully and below errors have disappeared from the backups! Below failed backup errors is a nightmare for admins and also a hard one to solve. Of course our disks haven’t had any physical errors or reporting physical failure BUT rather were extremely fragmented (as the diskeeper failed to keep up) and database was as you can see giving I/O errors!

Imagine below all RED!!! And now nicely optimized!

Qte

Backup- dg-mon-erp.DAGMAR.local

V-79-57344-65085 - There was a problem running the DBCC.
V-79-57344-65085 - There was a problem running the DBCC.

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:10936; actual 0:0). It occurred during a read of page (1:10936) in database ID 7 at offset 0x00000005570000 in file 'D:\SQL Server Data Files\Softmar.mdf:MSSQL_DBCC7'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB).

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

Backup- dg-mon-erp.DAGMAR.local

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:10936; actual 0:0). It occurred during a read of page (1:10936) in database ID 7 at offset 0x00000005570000 in file 'D:\SQL Server Data Files\Softmar.mdf:MSSQL_DBCC7'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB).

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

Uqte

So I’d like to share on how to make this great tool to run weekly as a task to defrag and optimize your fixed disks (not removable ones)!

Open your 2008 or 2003 servers and go to your Task Schduler. 

Create a new task for each and select to run a program as per below:

You can give them names as Udefrag & Uoptimize !

For defrag: 

C:\WINDOWS\system32\udefrag.exe --all-fixed

For optimize:

C:\WINDOWS\system32\udefrag.exe -o --all-fixed

*Note: if you want all to be included just remove word -fixed and all you drives will checked!

Select when for example I prefer Friday night at 23:59 for defrag and then Sunday 23:59 for the Optimize. Save and open properties, check if all ok and correct account/credentials entered to run the task!

You are done! And a great thank you to the developer(s) which I suggest all of us to support if their work is helpful to you!

* UltraDefrag was originally written by Dmitri Arkhangelski. He is the chief architect and the main programmer.

Justin Dearing proposed the idea for the boot time defragmentation and wrote the original manual. Also he wrote the UltraDefrag Scheduler.

Sayem Chaklader is the webmaster for the project.

Stefan Pendl is the project maintainer. As a true magician, he invented a lot of features, rewrote the documentation, the installer and the scripts used to build the program. Stefan performs intensive testing of all the new features. He wrote a set of special scripts to automate some stages of testing.