Image-3.png

<div>
<div class="content wysiwyg-content">
I often restore a version of a prod database on top of a test database. &nbsp;Many times the test database will have active connections that i kill off with the activity monitor in ssms. (allowing the restore to proceed) &nbsp;Would putting the database in single-user mode offer me the same results of killing all active connections. &nbsp;what are the risks of putting it in single user mode?<br />
<br />
proposed steps. &nbsp; <br />
<br />
put test database in single-user mode<br />
restore production database to the test database.<br />
<br />
will the test database be in single user mode after the restore.
</div>
</div>


I often restore a version of a prod database on top of a test database.  Many times the test database will have active connections that i kill off with the activity monitor in ssms. (allowing the restore to proceed)  Would putting the database in single-user mode offer me the same results of killing all active connections.  what are the risks of putting it in single user mode?

proposed steps.   

put test database in single-user mode
restore production database to the test database.

will the test database be in single user mode after the restore.

Killing spid's or processes on a sql server from the

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.