first take log backup
then it truncates tlog but the size wouldnt change
so then shrink the log file now
DBCC SHRINKFILE(pubs_log, 1)
Take recurrent full backups and all uncommitted transactions will be flushed out
Author Archives: Ram - Page 73
My Transaction Log is bloated…what do I do?
Posted by Ram
on April 7, 2015
No comments