title: SQL Server 2016 - Log rotation
body: <p>I am working with SQL Server 2016 and TFS 2018.
  In my TFS I have a collection : DefaultCollection.
  This collection has a log file (DefaultCollection_Log) which is growing fast.</p>
  
  <p>I'd like to set a time period (let's say 2 weeks for examples) for log retention. This is, every day (for example)  SQL Server should delete data in my DefaultCollection_Log file older than 2 weeks.</p>
  
  <p>How can I acomplish that?</p>