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
- 11450 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 |
Do you know data definition language, data control language and data manipulation language?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
What are SSL and TSL protocols?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is molap and its advantage? : sql server analysis services, ssas
Can a cursor be updated? If yes, how you can protect which columns are updated?
Can primary key be a foreign key?
Does full backup break log chain?
What is mean by candidate key?
Define msdb database?
-
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)
