How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?

Answer Posted / abc

sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the on update no action do?

669


What are the steps you can take to avoid “deadlocks”?

606


How many triggers you can have on a table?

609


Can sql server 2016 run on windows 7?

589


What is buffer cash and log cache in sql server?

693






How to create a testing table with test data in ms sql server?

629


What is self join in sql server joins?

641


What is the stored procedure?

652


How to implement service broker?

602


What is normalization of database? What are its benefits?

586


How network traffic be reduced by using the stored procedure?

664


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

647


Explain the disadvantages of cursors?

678


How to execute the cursor queries with "open" statements?

698


What is transaction server implicit?

604