Tag Archives : backups


A real head-scratcher

Backup script skipping databases – and the fix!

I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost. One day I noticed that the backup script hadn’t backed up all of the databases on my instance. I checked the job history, no errors. I checked the SQL Server log, no errors. I checked the Windows […]


RYO Maintenance Plan – Database Backups, Part 3

I’ve covered creating my backup directories and the actual backup of the database(s). The last thing I want to do in my process is clean up any old backup files. Once again, I want to allow for some flexibility in my procedure. Much like the maintenance plan task I’m replacing, my procedure should be able […]

4 out of 5 DBAs agree

only you

RYO Maintenance Plan – Database Backups, Part 2

Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups. Today we’ll get into the meat of the database backup procedure itself. If you’ll recall, this procedure has to meet some specific criteria: It will need a minimum of tweaking to implement and maintain. It […]