Wednesday, June 6, 2012

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.