Downloads - SQL Server 2005
Here you can download the last version of the SQL Server Maintenance Solution that runs on SQL Server 2005.
- MaintenanceSolution.sql: Creates all the objects and jobs
- DatabaseBackup.sql: Stored procedure to back up databases
- DatabaseIntegrityCheck.sql: Stored procedure to check the integrity of databases
- IndexOptimize.sql: Stored procedure to rebuild and reorganize indexes and update statistics
- CommandExecute.sql: Stored procedure to execute and log commands
- CommandLog.sql: Table to log commands
- Queue.sql: Table for processing databases in parallel
- QueueDatabase.sql: Table for processing databases in parallel
The SQL Server Maintenance Solution is available on GitHub.
Script to check version timestamps: VersionCheck.sql
Sign up for the newsletter to be alerted about updates to the solution.