Backup, Index & Integrity database utility

Codeplex is now hosting a popular set of utilities for SQL Server 2005, 2008 & 2008 R2 written and maintenance by Ola Hallengren.

There are many SQL Server DBAs that use Ola’s utilities and SQL Server Magazine has written about his work. He describes these utilities this way:

I have developed a solution for backup, integrity check and index optimization in Microsoft SQL Server 2005, Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.

If you would like to check it out, you can download these utilities here from Codeplex. Also click on the link to his site in this posting above to see how he compares his methods to SQL Server maintenance plans.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s