title: whats best practice for Log Truncation in SQL Server?
body: <p>i have a production DB in SQL server and wanted to put the final touches after the functionality is completed. prior to shipping it out i want to make sure i have some clean up in the SQL server DB and truncate and shrink log files?</p>
  
  <p>can i have a nightly job run to truncate logs and shrink files?</p>
  
  <p>this is what i have so far:</p>
  
  <pre><code>ALTER proc [dbo].[UTIL_ShrinkDB_TruncateLog]
  as
  
  -- exec sp_helpfile
  BACKUP LOG PMIS WITH TRUNCATE_ONLY
  
  DBCC SHRINKFILE (PMIS, 1)
  
  DBCC SHRINKFILE (PMIS, 1)
  </code></pre>
  
  <p><strong>EDIT:
  MY RECOVERY MODEL IS SIMPLE</strong></p>