Blog

Transactional Log Shrink Conditions in SQL Server

By Shivom Agarwal Dec 18 2012
In this blog, we will see how to Shrink the truncated log file in SQL Server.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 1.7k
  • 0
 The Purposes of this condition is Shrink truncated log file in SQL server database.
 
 ALTER
 DATABASE [Test] 
 SET
 RECOVERY SIMPLE; 
 GO
 
 -- Shrink the truncated log file to 1 MB. 
 

 DBCC
 SHRINKFILE (Test_log, 1); 
 GO
 
 -- Reset the database recovery model. 
 

 ALTER
 DATABASE [Test] 
 SET
 RECOVERY FULL;