Minion Backup (7)

ResourceDB doesn't backup like the other DBs.  Currently, in MB 1.2, you have to backup resourcedb with a postcode.  This is an update statement that adds a BatchPostCode to your system backup schedule.   Read More

Another take on the "last backup set" view. This pulls all databases on the  server, so every database will show up in the list (even if it has no backup). Gives you the latest full, diff, and log backup (if any) per database.   Read More

The function returns a list of databases that do not have an (undeleted) backup of type @BackupType within the last @BackupThresholdDays days (or alternately, within the last @BackupThresholdHours hours). See the code for limits and more documentation   The job uses the function to send alerts as needed.  By default, it sends an alert if: Any database does not have a full backup < 7 days old Any FULL database does not have a log backup < 1 hour old See the code for limits and more documentation.   Read More

This is for all v.1 versions of Minion Backup. It creates restore statements for multiple DBs. To use this just populate the #table with whatever DB names you want to restore and it looks in the Minion.BackupFiles table and build the stmts based off of the latest files in there. It takes the last full backup, the last diff and the last log. Currently though, in this version of the restore SP you have to script each backup type out separately. This isn't meant to be a complete restore solution in its current state.  It's meant to show you how to use the restore SP to build multiple restore stmts. To see an explanation of the input params of the restore SP itself, see the documentation.   Read More

View for MinionBackup that returns the last successful backup set for each database (most recent Full, most recent Diff, and all Log backups since the Full or Diff).   Read More

Quick update to the Pre/Post code to enable or disable xp_cmdshell if you have some policy that prevents it from always being enabled.  Version 1 doesn't do any checking to see if another "Minion" proc is running before disabling xp_cmdshell.   Read More

PowerShell script that finds all backup files older than $MinFileAge (days prior to current date) that are contained in the Minion.BackupSettingsPath destination(s). Script outputs (or deletes) any backup files that are not listed as existing ([IsDeleted] = 0) in the Minion.BackupFiles table.   Read More