Restart your SQL Server instance and it should then run in single-user mode. Append the -m to the end of the Startup Parameters box.Ĭlick Apply to save your changes.
If you’ve installed SQL Server 2008, 2005 or an earlier version, click Advanced tab. Type -m in the Specify a startup parameter box and then click Add. In SQL Server 2014 or 2012, click Startup Parameters tab. Select Properties from the drop-down menu. Choose SQL Server Services from the left panel and then right-click on desired SQL Server service that needs to run in single-user mode. Method 1: Start SQL Server in single-user mode through SQL Server Configuration Manager This can be either done via SQL Server Configuration Manager by setting the startup parameters or through the Command Prompt. I’m going to walk you through the process of putting your SQL Server database into single-user mode. Only one user can connect to the database.Any current connections to the database are dropped without warning.
When a database is started in single-user mode, the following events occur: Both actions require starting an instance of SQL Server in single-user maintenance mode. For example, you might need to restore your master database from a backup in the event of a failure or damage, detach the database and kill all the connections. There are certain situations when user may have to start a SQL Server instance in single-user mode.
0 kommentar(er)
