Tag: Backups

  • DBA Scripts: Generate Backup Jobs

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. A Readable Generator for Full Backups, Log Backups, and Cleanup 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 backup job framework as plain…

    Written by

    Peter Whyte

  • DBA Scripts: Get Backup Size Trend

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. What Your Backup Sizes Are Quietly Telling You Nobody watches backup file sizes month to month, they just watch that the backup succeeded. But backup size is a free, already-collected proxy for data growth rate, and it catches two things a success/failure check…

    Written by

    Peter Whyte

  • DBA Scripts: Get Last Restore History

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. A Backup You’ve Never Restored Is a Guess, Not a Plan Every DBA can point to a backup schedule. Far fewer can point to proof that any of those backups actually restore. A backup job finishing green tells you the file was written,…

    Written by

    Peter Whyte

  • DBA Scripts: Generate Backup and Restore Scripts

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Backup & Recovery Stop Hand-Typing Database Names Into Backup Commands Writing a one-off BACKUP DATABASE or RESTORE DATABASE command for a single database is trivial. Doing it correctly for every database on an instance, with a consistent naming convention, the right options,…

    Written by

    Peter Whyte

  • DBA Scripts: Backups and Recovery

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Backup and recovery is the one area of SQL Server administration where “probably fine” isn’t good enough, a backup you haven’t verified restores is a belief, not a backup. Nine scripts across this site cover the whole lifecycle: what recovery model each database…

    Written by

    Peter Whyte

  • DBA Scripts: Get Recovery Model Audit

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Backup & Recovery The Mismatch That Fills a Disk A database’s recovery model is a promise about what kind of restore is possible, FULL and BULK_LOGGED promise point-in-time recovery, backed by log backups; SIMPLE promises none, and truncates the log on its…

    Written by

    Peter Whyte

Start Here

The Pillars

Blog Categories

Latest Posts

Blog Tags

Access (4) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Jobs (3) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (10) SQL Agent (5) SQL Scripts (17) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)