How can we help you today? How can we help you today?

Can't setup Transaction Log backups for User databases

The Beta stops me from scheduling a Transaction Log backup for all "User" databases ("EXCLUDE msdb, master, model") if any of the user databases are set to SIMPLE mode.

I think SQL Backup should be smart enough to allow me to still setup the schedule and only perform transaction log backups on FULL / BULK-LOGGED databases.

....

I'd like to be able to set most of my servers with the following schedule:

All User databases Full backup 6AM
All User databases Diff backup 6PM
All User databases Transaction backup Hourly

However most servers have a mix of SIMPLE and FULL logging mode databases.
JulianKuiters
0

Comments

2 comments

  • wallacea
    Hi Julian,

    Thanks for the feedback. You have a good point. We will be looking to make changes to the backup wizard for the final release that should make this sort of thing much easier.

    Thanks,
    Alan
    wallacea
    0
  • JulianKuiters
    Thanks Alan
    JulianKuiters
    0

Add comment

Please sign in to leave a comment.