Interested to Buy Any Domain ? << Click Here >> for more details...
How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 11608 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 |
What is the difference between count () and rowcount ()?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Can Somebody tell me the difference between Clustered & Non- Clustered Index??
How to disable stored procedure sql server?
What is difference between after and before?
How check triggers in sql server?
What will be query used to get the list of triggers in a database?
How to rebuild indexes with alter index ... Rebuild?
How to configure odbc dsn with different port numbers?
How to set database to be read_only in ms sql server?
After removing a table from database, what other related objects have to be dropped explicitly?
How to update a field in SQL after ALTERING a row?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
