Showing posts with label restart. Show all posts
Showing posts with label restart. Show all posts

Wednesday, March 7, 2012

Audit Level None still auditing failed logins

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.

Audit Level

Hello Group,
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
RichYes you need to restart.
-Sue
On Fri, 17 Feb 2006 08:03:29 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>Hello Group,
>when the Audit Level is changed from Everything to Failure, do I have to
>stop and restart the SQL Server Windows Service?
>Rich

Audit Level

Hello Group,
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
Rich
Yes you need to restart.
-Sue
On Fri, 17 Feb 2006 08:03:29 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>Hello Group,
>when the Audit Level is changed from Everything to Failure, do I have to
>stop and restart the SQL Server Windows Service?
>Rich

Audit Level

Hello Group,
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
RichYes you need to restart.
-Sue
On Fri, 17 Feb 2006 08:03:29 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:
>Hello Group,
>when the Audit Level is changed from Everything to Failure, do I have to
>stop and restart the SQL Server Windows Service?
>Rich