taking T-backup not freeing any log space-EMERGENC | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

taking T-backup not freeing any log space-EMERGENC

HI<br /><br />My drive is full becos of a transactional file(10GB).I am taking<br />backups each 3 hrs but log file is same only. Pelase advice<br /><br /><br />i can see <br />Current size of logile : 10GB<br />used space of logfile :123MB<br /><br />But the physical logfile is of size 10GB <img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />( .Really donno how its happening.<br /><br /><br />
Have you tried to shrink your transaction log file? Also, are you making daily full backups of your database? Both of these are important tasks to perform on a daily basis. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
If you have scheduled the database maintenance tasks to optimize, reindex the database then the space on Tlog size will be expected to increase. As suggested by Brad you can shrink the log, using BACKUP LOG will decrease the size of virtual log and in order to reduce the physical use DBCC SHRINKFILE. For accuracy you can shrink the Tlog and check the growth of log file when the scheduled tasks are completed. Also consider to decrease the interval to 1 hour instead of 3 hours. 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.
]]>