How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10358 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
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
what is nonclustered index
What do we have to check in database testing?
What is data file in computer?
Explain what are the database objects? : SQL Server Architecture
What is the difference between deallocate cursor and close cursor?
What are trace flags and mention a few common trace flags used with sql server?
What are cascading parameters in ssrs reports?
What are the ways available in sql server to execute sql statements?
How to modify an existing stored procedure in ms sql server?
What is the difference between a function and a trigger?
Explain try...catch with sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How can we get count of the number of records in a table?
