Stored Procedure Based Maintenance Solution for Backup, Integrity Check and Index Optimization
[Here’s an email from Ola Hallengren]
I have a solution that I would like to share with the SQL Server
community. It’s a stored procedure based maintenance solution for
backup, integrity check and index optimization.
The backup stored procedure supports full, differential and log
backup. It creates backup directories, backups databases, verifies
backups and deletes old backups.
The stored procedure for index optimization does index rebuild online
or offline, index reorganization, statistics update, index
reorganization and statistics update or nothing based on fragmentation
level, LOB existence and index size.