You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute

You administer a Microsoft SQL Server 2012 instance.
You discover that the SQL Agent Error Log file is rapidly growing in size.
You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent
jobs execute.
What should you do?

You administer a Microsoft SQL Server 2012 instance.
You discover that the SQL Agent Error Log file is rapidly growing in size.
You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent
jobs execute.
What should you do?

A.
Execute the sp_cycle_agent_errorlog stored procedure.

B.
Configure event forwarding.

C.
Enable the Auto Shrink option on the master database.

D.
Enable the Auto Shrink option on the msdb database.

E.
Disable the Include execution trace messages feature.



Leave a Reply 1

Your email address will not be published. Required fields are marked *