title: How to mirror production SQL Server database with Local with ability to change local database for a period of time?
body: <p>I currently have a setup where I have a local website, a staging website, and a production website. I develop on my local using the staging database and then once the change is made, it is moved to staging, which configuration wise, is supposed to match production. If it works on staging, I pretty much know it'll work live, and I move it to production.</p>
  
  <p>As of now, the staging database is out of date with the changes made in production by our users. </p>
  
  <p>What I would like to hopefully accomplish would be to have some way that the staging database could be updated every night automatically. This would allow staging to be up to date, but allow us to make changes to staging that may be needed to test new changes, without it getting overridden immediately by a production update.</p>
  
  <p>Microsoft SQL Server if that helps. Believe it is 2008.</p>
  
  <p>To sum up, how would I be able to mirror Production database to staging database automatically every night?</p>