title: Delete records from SQL Server backup file
body: <p>It is an insane idea to delete records from backup since the notion of backup is to serve on disaster. But in our case, data deletion is a valid use-case.</p>
  
  <p><strong>Requirement:</strong> in brief, we are in need of a system which is capable of deleting a specific record from an active database instance and from all its backups.</p>
  
  <p>We have a fully functional internal system which is capable of performing the mentioned requirement of deleting data from active database. But what we don't know is how to do the same agonist all these database backups.</p>
  
  <p><strong>Question:</strong> </p>
  
  <ul>
  <li>Is it possible to find a specific record from a backup?</li>
  <li>Is there any predefined schema or data allocation style within SQL Server backup file, which allow us to isolate a specific record?</li>
  <li>Can you share any thoughts or experience you have on such style of deletion?</li>
  </ul>
  
  <p><strong>Note:</strong> we take 2 full backup daily and store a week worth (14 in total) at any point in time.</p>