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 : http://stackoverflow.com/questions/56628/how-do-you-clear-the-transaction-log-in-a-sql-server-2005-database


Published 5th Jun 2012 // #sql




comments powered by Disqus