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

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,


What type of index should you use on a fact table?

1 Answers  


Explain the concept of the DUAL table.

3 Answers  


how do see how much space is used and free in a tablespace

2 Answers   Genpact,


How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  


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

0 Answers  


What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  


Explain an ORA-01555

2 Answers  


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


What is the difference between Datapump & export/import?

2 Answers  


What is blocking and how would you troubleshoot it?

1 Answers  


What happens on checkpoint? : sql server DBA

0 Answers  


Categories