Red Gate forums :: View topic - log files not automatically backed up on new DBs
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

log files not automatically backed up on new DBs

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



Joined: 20 Jul 2012
Posts: 1

PostPosted: Fri Jul 20, 2012 8:07 pm    Post subject: log files not automatically backed up on new DBs Reply with quote

The nature of our environment requires us to create new DBs often. Using the "All Databases" option in SQL Backup it will automatically create a full and differential backup, at the next scheduled time for the new DB. However, it won't start performing trans backups on the new DB until you modify the job.

Is there a way to solve this?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Sat Jul 21, 2012 5:04 am    Post subject: Reply with quote

Could you please check the script for the transaction log backup job? Does it name the databases explicitly e.g.

BACKUP LOGS [db1, db2, ...] TO ...

If so, you'll need to add new databases to the list as and when they are created. You could amend the list to back up the transaction log for all databases running full/bulk logged recovery models e.g.

BACKUP LOGS [*] TO ...

or use an exclusion list e.g.

BACKUP LOGS EXCLUDE [db1, db2] TO ...

which will back up all databases running full/bulk logged recovery models except those listed.

However, the last 2 options will not automatically run a full backup if the transaction log backup job runs before the full backup. The next version of SQL Backup (7.2) will address this.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
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