You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains two SQL Server 2008 servers named CERTKILLER-DB1 and CERTKILLER-DB2.
CERTKILLER-DB1 does the transaction log backups and CERTKILLER-DB2 is to reset by using the SQL Server Surface Area Configuration.
However one morning you notice that the CERTKILLER-DB2 did not run the maintenance tasks automatically.
What should you do?
A.
You should consider resetting a full backup of the master database manually.
B.
You should consider resetting the Web service to only grant access to an administrator.
C.
You should consider resetting CERTKILLER-DB1 to use Windows Integrated authentication exclusively.
D.
You should consider resetting CERTKILLER-DB2 so that the SQL Server Agent service starts automatically.