How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / m.sivakumar
The SQLSERVR.EXE is located in binn directory of Sql server.
-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Define cross join in sql server joins?
What is awe?
Explain what is it unwise to create wide clustered index keys?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is parameterized reports in ssrs ?
How to test odbc dsn connection settings?
Explain sql delete command?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How can I tell if sql server is 32 or 64 bit?
What is intellisense?
How efficient you are in oracle and SQL server?
What is NOT NULL Constraint in sql server 2012?
What is delete query?
How would you use user_constraints table in DB?
How to create percentile function?