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
Monthly Archives: April 2015 - Page 19
My Transaction Log is bloated…what do I do?
Posted by Ram
on April 7, 2015
No comments