Interested to Buy Any Domain ? << Click Here >> for more details...
How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 11199 Views
- HCL, I also Faced
- E-Mail Answers
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
How does stuff differ from the replace function?
What are the advantages dts has over bcp?
what is a mixed extent? : Sql server administration
what is difference between NULL and ISNULL in SQL Server 2008?
What is the language structure to add a record to a table?
can an automatic recovery be initiated by a user? : Sql server administration
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to delete an existing row with delete statements in ms sql server?
What the different components in replication and what is their use?
How to include text values in sql statements?
How to create a testing table with test data in ms sql server?
What is the user of Primary key?
How to make conditional sum in ssrs?
What are the dis_advantages of stored procedures, triggers, indexes?
What are date and time data types in ms sql server?
