Advanced Search

SQL Server 2008 Truncate Transaction Log

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DECLARE @LogFileLogicalName sysname
  2. SELECT @LogFileLogicalName=Name FROM sys.database_files WHERE TYPE=1
  3. print @LogFileLogicalName
  4.  
  5. DBCC Shrinkfile(@LogFileLogicalName,100)

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.