Shared Flashcard Set

Details

SS 2008 1-2 Install & Configuration
SQL Server 2008 - Implementation & Maintenance
9
Software
Undergraduate 1
06/16/2013

Additional Software Flashcards

 


 

Cards

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
Enterprise.
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)}
Supporting users have an ad free experience!