title: SqlServer restore database error
body: <p>I'm using SQL Server 2008 R2, I need to restore a database from a .bak file. There is always an error that the database is in use until I restart the SQL Server service.</p>
  
  <p>Is there a better option to do that?</p>