Sunday, June 16, 2013

[SQL Server] ldf file size

[SQL Server] ldf file size


ldf file size

Posted: 15 Jun 2013 08:22 PM PDT

Dear AllI have a db for which recovory model is Full. And i am taking only full back up. .Ldf size is bigger than the .mdf file. I wanted to reduce the file size. On one site i saw following solution1. change the recovery model to simple2. change the ldf initial file size to 1mb3.Change the recovery model back to Full.Is it a correct way? What will be the side effects of this?RegardsKrishna1

No comments:

Post a Comment

Search This Blog