Red Gate forums :: View topic - Any way to automate triggering of "new" DB backup?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

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

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sergioza



Joined: 13 Nov 2013
Posts: 4

PostPosted: Fri Jan 10, 2014 5:44 pm    Post subject: Any way to automate triggering of "new" DB backup? Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Fri Jan 10, 2014 6:01 pm    Post subject: Reply with quote

Thank you for your support request.

To answer your questions:

Quote:

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.

Quote:

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group