error trapping on BACUP LOG - Backup, Recovery and Disaster Recovery

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » error trapping on BACUP LOG

error trapping on BACUP LOG

Options

Previous Topic · Next Topic

clubbing80s

Posted: Friday, January 25, 2008 2:16:01 AM

Rank: Newbie

Joined: 1/25/2008
Posts: 0
Points: 3

Hi
I would like to do error trapping when running BACKUP LOG and write it to a file or email it.. Also would like to find a way to test if it's worth running BACKUP LOG as I see if there have been no changes to the database / logs, it produceses errors. thus if I could test to see if there are changes to the logs / database and then only if there are I would exicute BACKUP LOG thus avoiding unnessary error being genirated ..
Greg

Scott Whigham

Posted: Monday, January 28, 2008 11:42:33 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Hi there -

As far as I know, there is no way to trap a BACKUP LOG statement in any type of a trigger; the only option I know of is to use Profiler and trap the sql events.

The only option I can suggest is do not let people that don't know the impact of taking transaction log backups back up your databases!

Users browsing this topic

Guest

Forum Jump

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