Transactional Log Shrink Conditions in SQL Server

By Shivom Agarwal Blogs | SQL Dec 18, 2012
In this blog, we will see how to Shrink the truncated log file in SQL Server.
 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;
COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs