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 a trigger what are the advantages of trigger?
How can a database be repaired?
Can we create clustered index on composite key?
SQL Server Architecture ?
What is the difference between an index and a unique index?
how to avoid cursors? : Sql server database administration
How to create function with parameter in sql server?
Tell me about normalization in DBMS.
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are diverse clauses that form a part of sql?
What is the difference between truncate and delete commands?
What is indexed view? How to create it?
How to create new databases with "create database" statements?
How to connect sql server management studio express to sql server 2005 express?
Differentiate between SQL and ORACLE joins and write their syntax.