Microsoft SQL Server:Resize Database Transaction Log by Detach/Atta
Use Detach/Attach method to re size/re create Transaction Log. 1.Detach Database. 2.Rename old Transaction log. 3.Attach Database. 4.Remove transaction log to attach. 5.Click Ok to Attach.It will create MODEL Database Sized Transaction Log.