You are a database administrator for AIOTestKing.com. You create a maintenance plan that includes shrinking your SQL Server 2005 databases and reorganizing your indexes once a week. You test the plan and discover that the database does not shrink as expected. You need to troubleshoot why the database is not shrinking. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Configure yourself as an operator for failed jobs.
B.
Review the job activity monitor.
C.
Review the maintenance plan history log.
D.
Configure an alert to respond to failed jobs.
E.
Review the job history log.
Explanation:
Use the Database Maintenance Plan History dialog box to find information about maintenance plans configured on the server. Viewing a job’s history allows you to see when the job ran, the status of the job as a whole, and the status of each job step in the job. You can see whether the job ever failed in the past, when the job last completed successfully, and what output the job created each time the job ran.