advanced code snippet search

Posted By

scholli on 02/10/11


Tagged

sql server


Versions (?)

SQL Server 2008 Truncate Transaction Log

 / Published in: SQL
 

URL: http://madhuottapalam.blogspot.com/2008/05/faq-how-to-truncate-and-shrink.html

Expand | Embed | Plain Text 
  1. Declare @LogFileLogicalName sysname
  2. SELECT @LogFileLogicalName=Name FROM sys.database_files WHERE Type=1
  3. print @LogFileLogicalName
  4.  
  5. DBCC Shrinkfile(@LogFileLogicalName,100)

Report this snippet  

You need to login to post a comment.