.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

Posted By :Subhransu Sekhar Jena     Posted Date :October 31, 2014    Points :40   Category :Sql Server 
SQL Server can be started from command line, using the SQLSERVR.EXE. This EXE has some very important parameters with which a DBA should be familiar with. -m is used for starting SQL Server in single user mode and -f is used to start the SQL Server in minimal confuguration mode.

You can also find related Interview Question to How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?  below: 

Which authentication mode lets you use both SQL Server logins and Windows logins?

  
Mixed Mode authentication mode lets you use both SQL Server logins and Windows logins? (More...)

Should validation (did the user enter a real date) occur server-side or client-side? Why?

  
Validation will be done in both sides i.e., at the server side and client side. Server side validation will be done even though client side validation performed on the code because of proper
security reasons. (More...)

Should user input data validation occur server-side or client-side? Why?

  
All user input data validation should occur on the server at a minimum. Additionally, client-side validation can be performed where deemed appropriate and feasable to provide a richer, more responsive experience for the user. (More...)

Client/Server Configuration?

  
Consists of two elements, Client and Server

Server:
1. A centralized element which provides resources to client
2. Manages data, printers or network traffic
Client:
1. Manages local resources used by users such as monitor, keyboard, CPU and peripherals (More...)

How do we Unlock Particular User in Sql Server

  
First Login with Window Authentication then take Master Database
Afterwards, execute the below query

alter login databaseusername01 with password='password' unlock (More...)

Single Mode Fiber Optic cable?

  
1. A type of cable that has only a single strand of glass fiber with a thin diameter.

2. Fiber optic cables that use lasers are known as single mode cable. (More...)

How to find the last restart time and date of sql server?

  
First Check the recent error log
Then Check the creation of TempDb
Click Start and hit Run then type "Net Statistics server" in command prompt.
(More...)

What is the purpose of Linked Server Configuration in Sql Server?

  
It enabled us to query remote database servers of different providers.

Thus we can copy or select table data between multiple servers. (More...)

1.Should validation (did the user enter a real date) occur server-side or client-side? Why?

  
client side . there is no need to go to validate user input. If it relates to data base validation we need to validate at server side. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend