You work as the database administrator at Domain.com. The Domain.com network contains two SQL Server 2005 database servers named Certkiller -DB01 and Certkiller -DB02. Certkiller -DB01 hosts a database named CK_Sales that is used to store sales information for the company, while Certkiller -DB02 is used for reporting purposes only.
You want to be notified by e-mail when ever a syntax error event occurs on the CK_Sales database but you want to keep the number of e-mails to a minimum. You configure SQL Server Agent Mail and you define a SQL operator object on Certkiller -DB01 for your administrative user account. What should you do? (Each correct answer represents part of the solution. Choose three.)
A.
Assign the alert to an operator.
B.
Create an alert for error number 170 on Certkiller -DB01.
C.
Create an alert for error number 170 on Certkiller -DB02.
D.
Configure the alert to Net Send the operators.
E.
Configure the alert to e-mail the operators.
F.
Create an alert for messages that contain the name ‘ Certkiller -DB01’.
Explanation:
You need to create an alert for error number 170 on Certkiller -DB01. Error number 170 denotes a syntax error. The alert needs to be assigned to one or more operators and must be configured to notify the operator by e-mail.
Incorrect Answers:
C: Alerts should be created for the production database that is hosted on Certkiller -DB01. Certkiller -DB02 is used for reporting purposes only and does not require an alert.
D: You want the alert to notify by e-mail not by Net Send.
F: An alert for messages that contain the name ‘ Certkiller -DB01’ would trigger for all events on Certkiller -DB01. You only want to be notified of syntax error events.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: alerts [SQL Server], about alerts