Re-size SQL Logs

Root Folder
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
 
Article ID: 11, , Modified: November 3, 2014 at 10:57 AM

Add Feedback

Was this article helpful?

Share this article

FacebookGoogle+TwitterOther Social NetworksPrint