Do I need to restart SQL Services when i change the audit level to none so
that i do not capture failed logins in the error logs.
If so, is there any other way i can avoid logging those changes without
restarting the SQL Server as its in production.
Also how to do i retain only maybe 10 SQL error log files . We run
sp_cycle_errorlog every 4 days and is there a way to roll over after 10
files only...cos now we see errorlog files that go through errorlog.21,
errorlog.22 and so on till i have to delete them manually. Id like to have
maybe just 5 or 10 of them before they can be overwritten.
ThanksYou will have to recycle SQL Server to stop the audit logging. There is not
another way to stop it.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment