title: Best way to auto-restore a database every hour
body: <p>I have a demo site where anyone can login and test a management interface.</p>
  
  <p>Every hour I would like to flush all the data in the SQL 2008 Database and restore it from the original.</p>
  
  <p>Red Gate Software has some awesome tools for this, however they are beyond my budget right now.</p>
  
  <p>Could I simply make a backup copy of the database's data file, then have a c# console app that deletes it and copies over the original. Then I can have a windows schedule task to run the .exe every hour.</p>
  
  <p><strong>It's simple and free... would this work?</strong></p>
  
  <p><strong>I'm using SQL Server 2008 R2 Web edition</strong></p>
  
  <p><em>I understand that Red Gate Software is technically better because I can set it to analyze the db and only update the records that were altered, and the approach I have above is like a "sledge hammer".</em> </p>