MS SQL Server 2012 - DBA Articles

SET DATABASE - Multi-users to Single-user Mode



This article describes how to set a user-defined database to single-user mode in SQL Server 2012 by using SQL Server Management Studio. Single-user mode specifies that only one user at a time can access the database and is generally used for maintenance actions.

To set a database to single-user mode

Select SQL Server Name and then click Connect.



Right-click the Sales database to change, and then click Properties.



In the Database Properties dialog box, click the Options page.



From the Restrict Access option, select SINGLE_USER.



Click OK.



If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes.



Database ICON changes, when updated Restrict Access = SINGLE_USER Mode.



Limitation

If other users are connected to the database at the time that you set the database to single-user mode, their connections to the database will be closed without warning. The database remains in single-user mode even if the user that set the option logs off. At that point, a different user, but only one, can connect to the database.

More Reference URL: http://msdn.microsoft.com/en-us/library/ms345598%28v=sql.110%29.aspx

* * * * *


Email Your Comment To AUTHOR