Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to start SQL Server in minimal configuration mode?

Question Posted / guest


How to start SQL Server in minimal configuration mode?..

Answer / 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

More DB Administration Interview Questions

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

What is the difference between Datapump & export/import?

2 Answers  

what is asm?

0 Answers   Oracle,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories