Any way to automate triggering of "new" DB backup?

sergiozasergioza Posts: 9
edited January 10, 2014 12:01PM in SQL Backup Previous Versions
Hi,
There are 2 things we'd like to automate.
We have weekly full backup and daily differentials, we do both by specifying:
BACKUP DATABASES [*] TO DISK

1. The first problem is that if someone created anew DB and didn't notify DBA then this newly created DB will produce an error while trying to do differential backup and Full backup wouldn't happen till scheduled day.
Any automated way to fix this issue other than to monitor this manually?

2.Master Database differential backup is not allowed, any way to specify in the synttax "Backup All DBs But... ?

Many Thanx

S

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Thank you for your support request.

    To answer your questions:
    1. The first problem is that if someone created anew DB and didn't notify DBA then this newly created DB will produce an error while trying to do differential backup and Full backup wouldn't happen till scheduled day.
    Any automated way to fix this issue other than to monitor this manually?
    Assuming that you are using SQL Backup V7.1 or higher you need to add FULLIFREQUIRED keyword to your backup syntax by manually editing the job within SSMS -SQL Server Agent ->Jobs. Further information can be found in this HELP article.
    2.Master Database differential backup is not allowed, any way to specify in the synttax "Backup All DBs But... ?
    You can only perform Full backups of the master database, SQL will not allow you to perform differential or transaction log backups of the master database.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.