June 1, 2006 at 9:13 am
Is there a way to automatically create a % log full Alert when a database is created or apply the same alert to all existing databases on the server?
Arthur Lorenzini
June 2, 2006 at 7:26 am
Arthur
Create a job to do the alerting (send a mail, FTP a file to your desktop, whatever) and, instead of scheduling it to run at a certain time, have it run when a certain performance condition is met, namely that the % log space used exceeds a value you specify (I recommend 80). You will need to create a separate job for each database - you could script out the first job to make and amend the script to create the others.
John
June 2, 2006 at 9:31 am
In Enterprise Manager, if you go under the Management Section, SQL Server Agent, Alerts.
In the dialog box:
Type - "SQL Server performance condition alert"
Object - "dbname/Databases"
Counter - "Percent Log Used"
Alert if counter - "rises above"
Value - the percentage that you want alerted at. I agree with John that you should alert at at least 80%. If your transaction log tends to grow quickly, you might want to alert earlier.
Then go to the Response tab:
You can choose an operator to either email, page or net send.
You can also choose to execute a job, such as a transaction log backup.
Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply