Interested to Buy Any Domain ? << Click Here >> for more details...
How to start SQL Server in minimal configuration mode?
- 1 Answers
- 7969 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 ora 24313?what is the procedure to exclude that error?
how can you process messages in order asynchronously?
what functionality does oracle provide to secure sensitive information?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
when does an alert gets signaled?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Why would you call update statistics? : sql server DBA
how can you schedule a job in database?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is the role of dip user in our database?
What the different components in replication and what is their use? : sql server DBA
how to restore files with rman?
