To re-size the SQL logs (shrink them)
- Right click on DB -> Properties
- Select Options Menu
- Change recovery Mode to Full
- Click OK
- Repeat Steps 1-2
- Change recovery Mode to Simple
- Click OK
- Right click on DB -> Tasks -> Shrink -> Files
- Change File Type to Logs
- Select "Reorganize pages before releasing unused space"
- Set shrink to size
- Click OK
Article ID: 11, Created: November 3, 2014 at 10:57 AM, Modified: November 3, 2014 at 10:57 AM