<div>
<div class="content wysiwyg-content">
I have made SQL database backup before updating server to Server 2012<br />
After upgrade,I have attempted to restore database using SQL Server Management Studio &nbsp;and received error message Restore failed for the server localhost\MSDPM2012 <br />
Exclusive access could not be obtained because the database is in use
</div>
</div>


I have made SQL database backup before updating server to Server 2012
After upgrade,I have attempted to restore database using SQL Server Management Studio  and received error message Restore failed for the server localhost\MSDPM2012 
Exclusive access could not be obtained because the database is in use

Restore backup in SQL 2008R2

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.