SQL Server Parameters when starting Instance:
1) -m -> Single User Mode
2) -f -> Minimal Configuration Mode
3) -c -> Starts instance quickly by not contacting Service Control Manager.
4) -g -> To set MTL portion of SQL Server
5) -n -> Does not use the Windows application log to record SQL Server events.
6) -T -> Indicates that an instance of SQL Server should be started with a specified trace flag (trace#) in effect. Trace flags are used to start the server with nonstandard behavior.
7) -m <ClientApplicationName> -> Only connections from a specific client application are allowed.
1) -m -> Single User Mode
2) -f -> Minimal Configuration Mode
3) -c -> Starts instance quickly by not contacting Service Control Manager.
4) -g -> To set MTL portion of SQL Server
5) -n -> Does not use the Windows application log to record SQL Server events.
6) -T -> Indicates that an instance of SQL Server should be started with a specified trace flag (trace#) in effect. Trace flags are used to start the server with nonstandard behavior.
7) -m <ClientApplicationName> -> Only connections from a specific client application are allowed.
No comments:
Post a Comment