SQL Server Maintenance Scripts

When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s SQL Server Maintenance Solution.  Focusing on SQL Server Backups, SQL Server Integrity Checks, and SQL Server Index and Statistics Maintenance, it has pretty much become the go-to maintenance solution for many SQL Server database administrators.  We have it on all of our SQL Servers, it is part of our standard installation process.

My favorite thing about Ola’s solution is that it is actively maintained and updated.  He continues to push out updates and add new features, while also maintaining backward compatibility with previous versions of SQL Server.  He also makes sure it takes advantage of some of the latest SQL Sever features.  It even has the ability to back up databases to Azure Blob Storage.

If you’re not currently using Ola Hallengren’s SQL Server Maintenance Solution, I highly encourage you to check it out.  Using it is as easy as calling a stored procedure.  In fact, you can even use it with Express Edition.

This is part of a series of Getting Started posts that I’m doing in which I spotlight the tools I use in my day to day duties as a DBA.  I asked myself “What tools would I immediately install if I started a new job as a company’s first DBA?”  This series of posts are the answer to that question.  

(Visited 2,090 times, 1 visits today)

1 thought on “SQL Server Maintenance Scripts

  1. Pingback: SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.