How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10676 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
Sql Server can be started from command line, using the
Sqlserver.exe. This exe has some very important parameters
with which a Dba should be familiar with.
-m is used for starting Sql Server in single user mode and -
f is used to start the Sql Server in minimal confuguration
mode
| Is This Answer Correct ? | 10 Yes | 6 No |
Answer / sqlserverbuddy
1. STOP the SQL Server Service(Management Studio or Service)
2. Step into Root directory of the SQL server Instance
(Default or Named Instance)
3. Enter as given below for Default Instance
sqlservr -m
4. Enter as given below for Named Instance (MyServer)
sqlservr -m -s MyServer
5. Don't close the DOS screen which processing internal
activities.
6. Open the SQL Server management studio and Proceed
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rahul
1) type cmd in rum
2) Stop the Server from configuration manager first and
then In Command Window, Type net start mssqlserver -m for
starting the Service in single user mode.
3) Type net start mssqlserver -f to start the Server in
minimal configration.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can i Relate Tables in SSIS
What are the different ways of moving data/databases between servers and databases in SQL Server?
List the different types of collation sensitivities in sql server?
Determine when to use stored procedure to complete sql server tasks?
Do you know what is difference between stored procedure and user defined function?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
How do you know if sql server is running on your local system?
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
Explain different types of locks in sql server.
What do you understand by recursive stored procedures?
What do you understand by a stored procedure?
what's the maximum size of a row? : Sql server database administration
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
