How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / swapna
SQL Server can be started from command line, using the
SQLSERVR.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. Check
out SQL Server books online for more parameters and their
explanations.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Is mysql the same as sql server?
Is port 1433 secure?
When I run the sql server 2000 setup, it just hangs. What do I do?
How do you check sql server is up and running?
What is tablix?
How many types of stored procedures are there in sql server?
What is database white box testing?
What is stretch database in sql server?
How to create a stored procedure with a statement block in ms sql server?
What is trigger in salesforce?
Will count(column) include columns with null values in its count?
What are “phantom rows”?
What do you know about normalization and de- normalization?
How do I start sql server 2016?
What are SSL and TSL protocols?