Today we are going to see a wonderful set of utility, we might need to manage our SQL Server.
We are talking about SQL Server maintenance Solution.
"The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical enterprise environments, and it is used in many organizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free."
As you can see, it is a bunch of scripts. Basically we are able to perform:
- SQL Server Backup
- SQL Server Integrity Check
- SQL Server Index and Statistics Maintenance
"DatabaseBackup is the SQL Server Maintenance Solution’s stored procedure for backing up databases."
"DatabaseIntegrityCheck is the SQL Server Maintenance Solution’s stored procedure for checking the integrity of databases."
"IndexOptimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics."
All the above are supported on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.
Every utility is fully described and usage examples are given. Said that I don't think I should spend more words: go to the above web site and have a look for yourself!