I'm managing a SQL Server 2008 R2 and I keep getting this from my monitoring agent:
On alerts received, we have determined that, SQL Server database percent transaction log used for the databases has reached its threshold value.
1)SQLSERVER:DATABASES\PERCENT LOG USED\WEBANALYTICSSERVICEAPPLICATION_REPORTINGDB_FF5F9EFC-8305-44BE-BFA4-ECECCA27A261 90.7 %.
Action Needed: To prevent the transaction log files from growing unexpectedly. It is recommended to backup the transaction log files regularly to delete the inactive
transactions in your transaction log. Please schedule a regular backup of log files.
I have backed up the database and set a recurring back up but I still managel to get this message and error every day. What can I do to fix this problem.
Thank you,David Kellett
View Complete Post