Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How to start SQL Server in minimal configuration mode?

Question Posted / santhosh

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

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

837

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1439

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?

2589

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1966

What are the different sql server versions you have worked on? : sql server DBA

775

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

828

What the different components in replication and what is their use? : sql server DBA

768

what are the differences of where and if in SAS?

1900

what is the diffrence between core dba and apps dba?

2321

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3503

What is the default fill factor value? : sql server DBA

823

Why would you call update statistics? : sql server DBA

776

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

785

how can you get actual data change values from previous transactions in oracle?

827

What is the difference between dropping a database and taking a database offline? : sql server DBA

820