I have tested Minion Backup on a variety of SQL servers at our office, and everything looks great. I tried to roll out on our most mission critical server, and no luck. It is a 3 node Windows 2012 R2 Cluster with Sql 2012 R2. The instance I'm trying to back up has a sing DB in full recovery. I have it set to to a full daily and logs every 10 minutes. The system DBs are backing up fine, but the user DB never backs up. I looked in the Minion.BackupLog table, and it agrees it was skipped. I can't find any detail as to why it was skipped. Any tips on where I can look to find out why?
Hey Matthew, it sounds like you might be having some scheduling trouble. We’ve had some known issues with schedules that we believe we got worked out in this last release, 1.2.
Try downloading the latest version and see if that clears up your issue. If not, then let me know and I’ll work through other things with you that could be knocking the DB out of the run.
In the meantime if you’d like to send me your Settings tables in excel then I can also start taking a look at them to see if anything jumps out at me.
Also, one of the great things about the new version is the BackupMaster SP has a new test param that lets you see which schedules will be used at any given date and time. So you can use that to see if the schedule is being chosen.
Once you get it downloaded and installed, let me know and I’ll talk you through it.
Hey Matthew, I haven’t heard back from you on this. Are you still having the issue?
This was caused by an LS DB that was restored and it kept the LS settings so MB was filtering it out of the backup list.