Red Gate forums :: View topic - e-mail notifications
Return to www.red-gate.com RSS Feed Available

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

e-mail notifications

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Wed Feb 08, 2012 12:14 pm    Post subject: e-mail notifications Reply with quote

I use SQL backup 6 to take full and tran log backups and copy them to a network location.

For both backups I have set the On completion action to email me for any outcome.

When the log is backed up I recieve e-mails to say that both the backup and the file copy have completed but when the database is backed up I only receive one e-mail to say that the backup has completed.

If I go to he network location I can see that the full backup has been copied across, so why isnt it telling me like it does for the log?

Thanks
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Wed Feb 08, 2012 1:29 pm    Post subject: Reply with quote

When SQL Backup copies backup files for full, differential, filegroup and file backups, the copying is performed as part of the backup task. Hence, the e-mail you receive notifying you that the backup has completed should also have a line indicating that the backup file has been successfully copied to its destination.

For transaction log backups, the copying is performed by a separate process, that runs independently of the backup. Hence, when the backup completes, an e-mail is sent. Details of the file that needs to be copied are placed in a queue, and when the file is eventually copied to its destination by the 'copying' process, another e-mail is sent.

The reason its done this way is that in log shipping scenarios, it is critical that the transaction log backup files gets copied to its destination one way or another. By having a separate process perform the copy, SQL Backup can make multiple attempts to copy the file, without blocking the backup process.

If you want SQL Backup to copy the transaction log backup files as part of the backup process, use the USESIMPLECOPY option e.g.

Code:
EXEC master..sqlbackup '-sql "BACKUP LOG ... TO ... WITH USESIMPLECOPY"'

_________________
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
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Wed Feb 08, 2012 4:15 pm    Post subject: Reply with quote

d'uh - of course it does, sorry.

I think there's a argument that databases backup copies should be a separate process too. It just as important to me that my backups are sent to a network location as it is they are stored locally.

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