title: Backup/Restore database for SQL Server continuous integration testing
body: <p>What is the best way to restore a SQL Server database on our testing server from a snapshot taken in production.  Database is running on Windows Server 2003 with SQL Server 2008</p>
  
  <p>We are using Bamboo along with Ant scripts for continuous integration running on Ubuntu.</p>
  
  <p>I want to be able to restore the database to a backup taken from production and apply the latest update scripts. </p>
  
  <p>Any advise is greatly appreciated.</p>