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
- 11225 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
What are drilldown reports?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are the hotfixes and patches in sql server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is a DBMS, query, SQL?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is bulkcopy in sql?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What are the advantages dts has over bcp?
how many type of indexing in database?
What is the purpose of sql profiler in sql server?
What are the new features of sql server 2012 reporting service?
Name few endpoints exposed by ssrs 2012?
What is delete query?
