Truncate Logs

alter database <mydb> set recovery simple
 go
 
 checkpoint
 go
 
 alter database <mydb> set recovery full
 go
 
 backup database pubs to disk = 'c:mydb.bak' with init
 go
 
 dbcc shrinkfile (N'mydb_log' , 1)
 go

• Recommend on Facebook
• share via Reddit
• Share with Stumblers
• Tweet about it