Interested to Buy Any Domain ? << Click Here >> for more details...
How to start SQL Server in minimal configuration mode?
- 1 Answers
- 7939 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
what is the role of dip user in our database?
Why would you call update statistics? : sql server DBA
which background process invoke at the time of upgradation tell me???
What is the default fill factor value? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the different authentication modes in sql server and how can you change authentication mode? : 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
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the different sql server versions you have worked on? : sql server DBA
What are the recovery models for a database? : sql server DBA
what is asm?
what do you understand by fine-grained auditing?
What is a system database and what is a user database? : sql server DBA
how to restore files with rman?
how does an oracle clusterware manage crs resources?
