How to start SQL Server in minimal configuration mode?
- 1 Answers
- 6968 Views
- I also Faced
- E-Mail Answers
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you implement fine-grained auditing?
which background process invoke at the time of upgradation tell me???
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is ora 24313?what is the procedure to exclude that error?
what is the diffrence between core dba and apps dba?
How would you go about verifying the network name that the local_listener is currently using?
What the different components in replication and what is their use? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What would you do with an "in-doubt" distributed transaction?
what are the performance views in an oracle rac environment?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
