Blog

Transactional Log Shrink Conditions in SQL Server

Dec 18, 2012 Blogs | SQL Language
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;
  • 287rank
  • 47K readers
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