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
- 11198 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ganeshsamurti
• Open "Control Panel->Administrative Tools->Services"
• Mouse right click on specified SQL Server instance service
and select "Properties" menu to bring up following
configuration window:
• Specify start parameters as following:
-s{ Instance name } -m
If instance is default instance (no instance name) ,then
just enter
-s -m
• Restart the SQL Server instance service
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is data source view or dsv? : sql server analysis services, ssas
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How many databases can we create in a single server?
What is a db view?
What is raid? : SQL Server Architecture
What is an entity-relationship diagram (erd)?
What is user-defined functions? What are the types of user-defined functions that can be created?
How much memory that we are using in Logshipping Concept?
What to check if a User database is locked?
Name the different type of indexes in sql?
What is server-level principal?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Differentiate between ms sql server reporting services vs crystal reports?
List few advantages of stored procedure.
