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


Please Help Members By Posting Answers For Below Questions

What is a trigger what are the advantages of trigger?

611


How can a database be repaired?

648


Can we create clustered index on composite key?

604


SQL Server Architecture ?

2011


What is the difference between an index and a unique index?

635






how to avoid cursors? : Sql server database administration

568


How to create function with parameter in sql server?

644


Tell me about normalization in DBMS.

681


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

808


What are diverse clauses that form a part of sql?

681


What is the difference between truncate and delete commands?

641


What is indexed view? How to create it?

674


How to create new databases with "create database" statements?

652


How to connect sql server management studio express to sql server 2005 express?

654


Differentiate between SQL and ORACLE joins and write their syntax.

672