You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Users regularly report that they receive error messages stating that the transaction log is full. When they get this message, their data changes fail. You notice that disk space on AIOTestKing A is limited. You need to configure AIOTestKing A to automatically prevent users’ data changes from failing due to full transaction logs. What should you do?
A.
Configure event notification at the database level for the LOG_FILE_AUTO_GROW event. Configure the Service Broker to automatically notify database administrators of the event.
B.
Double the maximum size of all of the transaction logs. Set the transaction logs to automatically grow by 30 percent.
C.
Create SQL Server performance condition alerts to run a job that backs up the transaction log and sends an e-mail message to database administrators by using Database Mail when the transaction log exceeds the counter.
D.
Configure event notification at the server level for the LOG_FILE_AUTO_GROW event. Configure the Service Broker to automatically notify database administrators of the event.