Lalit-Workz: How does one truncate a transaction log file in MS SQL

Friday, December 21, 2007

BACKUP LOG <DB NAME> WITH TRUNCATE_ONLY
USE <DB NAME>
DBCC SHRINKFILE (<Log Logical Name>, 20) -- where 20 = 20 MB

Unknown said...: EXEC sp_dboption , 'trunc. log on chkpt.', 'True'; 10:39 PM
Unknown said...: Use 'database Name'
GO

Alter Database 'database Name' Set Recovery Simple
GO

Alter Database 'database Name' Set Recovery Full
GO

DBCC SHRINKFILE ('log file name', 1)
GO; 3:13 PM
Unknown said...: Very helpful...; 2:38 PM