Friday, October 10, 2014

0 Start SQL Server in Single-User Mode

Add –m in the sql server start up parameter to start SQL Server in Single User Mode.

image

Make sure you stop sql agent otherwise, sql agent will take the only connection right away.

Reference

http://msdn.microsoft.com/en-us/library/ms188236.aspx

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates