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.

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response