Tag: Maintenance

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. A Readable Generator for Integrity Checks and msdb Housekeeping If you’re already running Ola Hallengren’s maintenance solution, this won’t replace it, but the approach here might still be useful: a small, readable T-SQL generator that builds a housekeeping job framework as plain sp_add_job…

This post has been split into a pillar and three focused posts, each generator script now has its own page with its own real bugs, Example Output, and Related Scripts, rather than three topics crammed into one long post. Start at the hub: SQL Server Maintenance Job Framework All three scripts, and the repo links,…

Part of the DBA-Tools Project, in the Maintenance and Automation area. If you’re already running Ola Hallengren’s maintenance solution, this framework won’t replace it, but the approach might still be useful: three small, readable T-SQL generator scripts that build the same category of scheduled job framework, full and log backups, backup cleanup, DBCC CHECKDB, index…