How To Restart Sql Server In Single User Mode? How To Start Sql Serve

1.	How To Restart Sql Server In Single User Mode? How To Start Sql Server In Minimal Configuration Mode?
Answer» 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. 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.

How To Restart Sql Server In Single User Mode? How To Start Sql Server In Minimal Configuration Mode?

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Values That Can Be Specified For Optimizer Mode Parameter ?
What Is A Trace File And How Is It Created ?
How Many Number Of Columns A Record Group Can Have?
What Does The Term Panel Refer To With Regard To Pages?
What Is A Master Detail Relationship?
What Is A Library?
What Erase Package Procedure Does ?
What Is Mean By Program Global Area (pga) ?
What Is The Use Of Parfile Option In Exp Command ?
What Is Overloading Of Procedures ?