You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. All company servers run Windows Server 2003 and are part of an Active Directory domain. Company policy states that all servers are shut down each night. A SQL Server Agent backup job is configured to run on AIOTestKing A each morning at 09:00.
On the mornings when AIOTestKing A has not been turned on by 09:00, the job fails to start, and you must manually start it. You need to ensure that AIOTestKing A is backed up automatically each morning. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Configure the SQL Server Agent service to start when AIOTestKing A starts.
B.
Configure a SQL Server Agent backup job to start when the CPU of AIOTestKing A is idle.
C.
Configure a SQL Server Agent backup job to execute when the SQL Server service starts.
D.
Configure a SQL Server Agent backup job to execute when the SQL Server Agent service starts.
E.
Configure the SQL Server service to start when AIOTestKing A starts.
Explanation:
You should configure the SQL Server Agent to start when AIOTestKing A starts because it will be started each morning. You should also configure the SQL Server Agent backup job to start when the SQL Server Agent starts because the backup job needs that the Agent is running in order to execute.