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...


How to start SQL Server in minimal configuration mode?



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

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,


What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  


any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,


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 are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  


Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,


the process of adding a cpu in sql server is called..?

2 Answers   TCS,


What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


what is rebuild index??

2 Answers   IBM, Sapient,


Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  


Categories