Posts

Showing posts from June 6, 2012

Microsoft SQL Server:Resize Database Transaction Log by Detach/Atta

Image
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.