title: Restoring SQL Server databases on to UAT from Prod
body: <p>I would like to restore prod databases to UAT on a regular schedule. I want to see if this is possible in MS SQL Server. </p>
  
  <ol>
  <li>Full Backup prod at beginning of month</li>
  <li>Restore UAT with the above full backup. Keep a snapshot of UAT</li>
  <li>Work on UAT</li>
  <li>Restore UAT to that snap shot</li>
  <li>Restore UAT from differential backups (rather than full to save time) in prod from the snapshot time.</li>
  <li>Update snapshot to the new snapshot</li>
  <li>Continue steps 3-6 until end of month.</li>
  </ol>