[SQL Server] 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 |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment