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
What is difference between sql and sql server?
Write query to return all rows sql?
What is normalization of database?
How do I perform an unattended install of sql server 2000?
Do you know the different ddl commands in sql?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Does a server store data?
How many columns can exist together per table?
What is the sql profiler?
What is the tcp/ip port on which sql server runs?
How is a full-text index updated?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What are sp_configure commands and set commands?
Difference between report and query parameter. Why do we need different type of parameter?
How to create a local temporary stored procedure?