Transaction log full | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transaction log full

This is the situation: The database is 6 Gbytes.
Our system will do trsaction log back up every 1 hour. The
log size actually is $24M, so really small. Web server will make trsaction to this database.
When the time transaction log backup job kick in at 5:00
PM (it happens every hour), Our error log have this error
message "Trsaction log full". Actually the web site
experiences like the database is dead. There are 340M free disk space. The log will grow 15M each
time dynamically with unlimited restriction. Will the trsaction log backup use a lot temperary space ?
Will it use around 340M to keep the trsaction log backup
happen. The actually log size at this moment is only 24M.
we have 340M free disk space, trsaction log will only
extend 15M each time. I just want to check everyone to see if trsaction log
backup use a log temporary space. That’s why we have this
error message at the time we are doing trsaction log
backup. Thanks.

Probably transaction log growth is limited. Try to set it to unlimited and backup log (WITH TRUNCATE_ONLY) before running a full backup to keep it small. Bambola.
What are the settings for Tlog on the database?
How often you schedule the Tlog backups? _________
Satya SKJ

I believe that transaction log backup does take some space. And also its a performance recommendation to have 20% free disk space especially when the disk system is NTFS. try freeing up some space and see if the problem persists. HTH. Gaurav
]]>