Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: How to shrink the transaction log file on SQL 2008 (SQL)
Title: How to shrink the transaction log file on SQL 2008 Language: SQL
Description: The truncate log option has been removed so for a database in Simple mode this is an alternative Views: 286
Author: Stephen Smith Date Added: 7/20/2012
Copy Code   
DBCC SHRINKFILE(DB_log)

(db in simple mode only)