DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Clear Transaction Log From SQL Server Database

12.15.2011
| 2010 views |
  • submit to reddit
        Clear the transaction Log if you are facing a low disk space on the database server.
 
To truncate log, use the following commands:
 
DBCC SHRINKFILE('logfilename', 1)
BACKUP LOG redeoba WITH TRUNCATE_ONLY DBCC SHRINKFILE('logfilename', 1)
 
where log filename is usually database name, i.e., northwind.log.

<a href="http://www.java-forums.org/blogs/spring-framework/"><strong>Spring Framework</strong></a>