You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains two SQL Server 2008 servers named ABC-DB1 and ABC-DB2. ABCDB1 is configured to automatically run a maintenance job ABC_JOB10 at regular intervals. Alls is
going well for months.
Then one morning your boss, Miss Tess King, notifies you that the ABC_JOB10 has not been run.
How should you do to remedy this situation? Select two.
A.
Modify the SQL Server Agent job.
B.
Start the SQL Server Surface Area Configuration.
C.
Modify the Maintenance plan.
D.
Reconfigure ABC-DB1 to use mixed mode authentication.
E.
Reconfigure ABC-DB2 to use mixed mode authentication.
F.
Reconfigure ABC-DB1 so that the SQL Server Agent service starts automatically.
G.
Reconfigure ABC-DB2 so that the SQL Server Agent service starts automatically.
H.
Reconfigure ABC-DB1 to use Windows Integrated authentication exclusively.
I.
Reconfigure ABC-DB2 to use Windows Integrated authentication exclusively.
Explanation:
Use SQL Server Surface Area Configuration to enable, disable, start, or stop the features,
services, and remote connectivity of your SQL Server 2005 installations. You can use SQL Server
Surface Area Configuration on local and remote servers.
In this scenario a plausible source for the problem is that SQL Server Agent service on ABC-DB1
no longer is configured to start automatically.