SQL Server 2008 – Shrink database and truncate transaction log file

As part of daily monitoring task, we checked production server and found that log file was growing more frequently for some of databases compare to others. Its throwing transaction log file is full for database ‘DB1’ and so on. As primary steps we took the log backup for the database using command Backup log db1 ...