title: Recover table records from months ago?
body: <p>We recently ran into a huge issue in which we lost critical usage information for the months of August-October 2019. </p>
  
  <p>I have set out to try recover this data. I found our SQL Server 2017 database is set to full recovery thankfully because I read some threads that if this wasn't the case, then we would be out of luck.</p>
  
  <p>With that, I'm trying to run a stored procedure I found here <a href="https://raresql.com/2012/04/08/how-to-recover-truncated-data-from-sql-server-without-backup/" rel="nofollow noreferrer">https://raresql.com/2012/04/08/how-to-recover-truncated-data-from-sql-server-without-backup/</a></p>
  
  <p>I'm running into some permission issues but assuming I have permissions, would it be possible to recover such data from 3-4 months ago? I want to know before proceeding asking for permissions and wasting DBA's time. If not, are we truly outta luck? Could 3rd party tools like ApexSql work?</p>
  
  <p><strong><em>Backstory if interested what's going on:</em></strong></p>
  
  <p>What happened is the powershell script we have on our windows server generates csv files containing usage information from a usage table that gets updated every 5 mins with usage data and sends them over to a linux server via connect direct FTP service daily. Once the file is sent, the script truncates the usage table because we dont want to run into performance issues as data continues building up in 1000s of records daily. </p>
  
  <p>At that point of time, we didn't consider archiving the export files but now we learned our lesson and started archiving them since. What happened was the ftp service stopped running on linux server and so no one was notified for 2 months about this, and management now sees a gap in the usage report for those missing months, and they're not happy about it.</p>