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
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Can you use order by when defining a view?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is the recursive stored procedure in sql server?
Explain the database you used in your final year project?
How to create a simple user defined function in ms sql server?
How would you choose between a clustered and a non-clustered index?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is user defined datatypes and when you should go for them?
Is it possible to update the views? If yes, how, if not, why?
What is compound operators?
What are commit and rollback in sql?
Can you explain full-text query in sql server?
Can I save my report as html, excel or word? : sql server management studio
Why the trigger fires multiple times in single login?