Chapter 10 Monitoring and Troubleshooting
- 1 What protocol and port number need to be open between the client machine and SQL Server for clients to resolve instance names to port numbers?
- A TCP 1433
- B TCP 1434
- C UDP 1433
- D UDP 1434
The correct answer is D. The SQL Server Browser listens on UDP port 1434 while the default instance listens on TCP port 1433. The other two ports listed are not used by SQL Server.
- 2 You have been informed that a job has been failing. Where should you look to see why the job has failed?
- A ERRORLOG file
- B SQLAGENT.OUT file
- C Job history within SQL Server Management Studio
- D Windows Application log
The correct answer is C. Job history is written to the msdb.dbo.sysjobhistory table, which can be viewed from within ...
Get The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
