Advanced Search

Return to Snippet

Revision: 41008
at February 10, 2011 20:40 by scholli
Initial Code 
Declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name from sys.database_files where Type=1
print @LogFileLogicalName

DBCC Shrinkfile(@LogFileLogicalName,100)
Initial URL 
http://madhuottapalam.blogspot.com/2008/05/faq-how-to-truncate-and-shrink.html
Initial Description 









Initial Title





SQL Server 2008 Truncate Transaction Log









Initial Tags





sql, server









Initial Language





SQL