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
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?
what is logical system in sap basis
Query processing is slow(eg select query)how will u solve that
what is the use of ocr?
What happens on checkpoint? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what do you understand by fine-grained auditing?
what are the benefits of flashback feature?
what is the role of dip user in our database?
when does an alert gets signaled?
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.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the default port no on which sql server listens? : sql server DBA
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?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA