Re-size SQL Logs

To re-size the SQL logs (shrink them)
 
  1. Right click on DB -> Properties
  2. Select Options Menu
  3. Change recovery Mode to Full
  4. Click OK
  5. Repeat Steps 1-2
  6. Change recovery Mode to Simple
  7. Click OK
  8. Right click on DB -> Tasks -> Shrink -> Files
  9. Change File Type to Logs
  10. Select "Reorganize pages before releasing unused space"
  11. Set shrink to size
  12. Click OK
 

Add Feedback