Term
| DBCC CHECKDB executes what 3 commands? |
|
Definition
DBCC CHECKALLOC; consistency of disk space allocation
DBCC CHECKCATALOG: catalog consistency
DBCC CHECKTABLE: catalog consistency |
|
|
Term
| What is the main use of the Configuration Manager? |
|
Definition
| Change service account passwords. |
|
|
Term
| Why should the Configuration Manager be used to change service account passwords. |
|
Definition
| Because it includes the code to regenerate the service master key that is critical to the operations of SQL Server services. p.20 |
|
|
Term
| What is a broadcast enumaration and how is it disabled? |
|
Definition
| A special broadcast command to locate any servers running SS. Disabled with Configuration Manager via "Hide Instance". |
|
|
Term
| What editions of SS support multiple instances on a server? |
|
Definition
|
|
Term
| What is the purpose of SQL Server Browser? |
|
Definition
to provide instance and port information to incoming connection requests.
http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/ |
|
|
Term
| When should the SQL Browser service be installed? |
|
Definition
| When there are multiple instances on the machine or dynamic ports are being used. |
|
|
Term
| How do you connect to a second instance of SQL Server if the Browser Service is not available. |
|
Definition
You must provide: IP address: instance_name: Port
EX: 100.155.123.33\UPDB-TEST,1434 |
|
|
Term
| What port is used used by the SQL Server Browser service? |
|
Definition
UDP 1434
{1 plus the TCP port(1433)} |
|
|
