How to start SQL Server in minimal configuration mode?

Answer Posted / santhosh

In a Command Prompt window, you can start the SQL server in
minimal configuration mode by typing: sqlservr -c -f

This command also starts the SQL server in single-user mode.
Also, the server will not run any startup stored procedures.
Additionally, when you start the SQL server in minimum
configuration mode, then SQL Server automatically sets the
size of tempdb to 2 MB on its default device. You must then
manually increase the size of tempdb as necessary.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2241


what is logical system in sap basis

1395


Query processing is slow(eg select query)how will u solve that

7260


what is the use of ocr?

818


What happens on checkpoint? : sql server DBA

813


How would you go about verifying the network name that the local_listener is currently using?

3000


what do you understand by fine-grained auditing?

857


what are the benefits of flashback feature?

809


what is the role of dip user in our database?

2249


when does an alert gets signaled?

795


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1949


suppose you want to audit specific activities on sensitive data. How can you achieve that?

785


What is the default port no on which sql server listens? : sql server DBA

872


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2607


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

828