Blog

Transactional Log Shrink Conditions in SQL Server

Posted 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.
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.