<div>
Go To Management, Activity Monitor and kill the processes that are accessing the database. These processes are the ones that interupt the restore. This should work.<br />
<br />
Also remember to clear your connection pool after you restore your database else you may find &nbsp;'A transport-level error' . This error can be removed by <br />
System.Data.SqlClient.SqlC<wbr />onnection.<wbr />ClearPool(<wbr />new System.Data.SqlClient.SqlC<wbr />onnection(<wbr />string.For<wbr />mat(YOURCO<wbr />NNECTIONST<wbr />RING)));
</div>


Go To Management, Activity Monitor and kill the processes that are accessing the database. These processes are the ones that interupt the restore. This should work.

Also remember to clear your connection pool after you restore your database else you may find  'A transport-level error' . This error can be removed by
System.Data.SqlClient.SqlConnection.ClearPool(new System.Data.SqlClient.SqlConnection(string.Format(YOURCONNECTIONSTRING)));

<div>
<div class="content wysiwyg-content">
While restoring the SQL Server database, I got the message:<br />
Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally.<br />
<br />
Are there other ways of making it work except of restarting db server or dropping the database?<br />
Thanks.<br />

</div>
</div>


While restoring the SQL Server database, I got the message:
Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally.

Are there other ways of making it work except of restarting db server or dropping the database?
Thanks.


Restoring the database: exclusive access could not be obtained

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.