How to shrink on Sql Server

  • First run this command (warning it doesn't backup anything) :
Backup log <DATABASENAME> with No_Log
  • Then you can shrink the journal with Management Studio :
    • Right click on the database,
    • All tasks,
    • Shrink database,
    • Files,
    • Select log file,
    • OK.

Source :

Published 5th Jun 2012 // #sql

comments powered by Disqus