February 14, 2008 at 2:40 pm
I was wondering how I can go about getting an email notification when my transaction log is full rather than having the user tell me about it or checking the sql error log? A scripted version would be great, not a big fan of GUI stuff.
thanks.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
February 14, 2008 at 2:50 pm
The easiest way would be to set up an sql server event alert. There's an alert definition for db log file being full.
_____________
Donn Policarpio
February 14, 2008 at 3:09 pm
I've tried to create a new alert but which of the severity should I be using?
nevermind, I see how it is done.
**
Still if someone knows how to do this via T-SQL, that would be great.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
February 14, 2008 at 3:32 pm
You can use the builtin alerts available with SQL Server for your req. But still if you want to handle via a TSQL then you would need to code with DBCC SQLPERF(logspace).
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply