sql cmd for transaction log full | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql cmd for transaction log full

Hey guys, rather than creating a gui monitoring app that connects automatically to the frontend, and scrape the gui screen for some sql errors like logfull, I’m thinking of going back to sql. This morning again, users were not able to write to the sql but they were able to login. However, they saw this message: program sql _exec
line 127
message connectivity error microsoft odbc sql server driver sql server the log file for database rekodb data is full. Backup the transaction log for the database to free up some log space. I would like to seek your assistance on what sql command I should use for this kind of message that will tell me that log is full. I did get a response last week but it’s more of log usage %. Thanks guys in advance. V
DBCC SQLPERF(LOGSPACE)
– for log file usage. sp_spaceused
to check database size. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>