Killing spid's or processes on a sql server from the
Posted on 2016-08-11
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?
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.