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

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

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

Postby sergioza » Fri Jan 10, 2014 5:44 pm

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
sergioza
 
Posts: 4
Joined: Wed Nov 13, 2013 5:07 pm

Postby eddie davis » Fri Jan 10, 2014 6:01 pm

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests

cron