Event Log: Log Backup Successes

Is there a way to prevent logging the sucessful SQL Server Log Backups to
the application event log? This is not success of the job (we have write to
event log on failure for the job).
We have sql servers with 70 or so different databases on them and back up
the logs every 15 minutes. Do the math. We have to keep our event logs very
large in order to retain the worthwhile information for any length of time.
Thanks!
Michelle
A common request but the answer is no. Even amending the dlevel in
sysmessages won't stop it writing to the event log. We have consolidated
servers with 8 instances and hundreds of databases and I agree it's a
complete pain in the neck :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"michelle" <michelle@.nospam.com> wrote in message
news:O1$BIWsCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Is there a way to prevent logging the sucessful SQL Server Log Backups to
> the application event log? This is not success of the job (we have write
> to
> event log on failure for the job).
> We have sql servers with 70 or so different databases on them and back up
> the logs every 15 minutes. Do the math. We have to keep our event logs
> very
> large in order to retain the worthwhile information for any length of
> time.
> Thanks!
> Michelle
>

Event ID 11 SQL 2000

Hi All,
Sorry to cross-post, but after looking through the
subjects, I thought my question belonged more in this
group.
My SQL server keeps logging this error;
Event ID 11 Source KDC: There are multiple accounts with
name MSSQLSvc/servername.domain.com:1433 of type 10
After following the instructions in the following article,
I found the 2 accounts that were suing the same SPN: they
were the "sa" account and the "administrator" account. I
don't think either of these should be deleted so how do
you fix this problem? What harm is caused by letting it go
on?
Thanks.
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;305971
Hi joh,
Try to reassign SPN with SETSPN.EXE utility which is available for download
with win2000 resource kit
Regards,
Daniel
"joh" <anonymous@.discussions.microsoft.com> wrote in message
news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
> Hi All,
> Sorry to cross-post, but after looking through the
> subjects, I thought my question belonged more in this
> group.
> My SQL server keeps logging this error;
> Event ID 11 Source KDC: There are multiple accounts with
> name MSSQLSvc/servername.domain.com:1433 of type 10
> After following the instructions in the following article,
> I found the 2 accounts that were suing the same SPN: they
> were the "sa" account and the "administrator" account. I
> don't think either of these should be deleted so how do
> you fix this problem? What harm is caused by letting it go
> on?
> Thanks.
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;305971
>
|||Thanks Daniel, I will give it a try.
joh
>--Original Message--
>Hi joh,
>Try to reassign SPN with SETSPN.EXE utility which is
available for download
>with win2000 resource kit
>Regards,
>Daniel
>"joh" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
article,[vbcol=seagreen]
they[vbcol=seagreen]
go
>
>.
>

Event ID 11 SQL 2000

Hi All,
Sorry to cross-post, but after looking through the
subjects, I thought my question belonged more in this
group.
My SQL server keeps logging this error;
Event ID 11 Source KDC: There are multiple accounts with
name MSSQLSvc/servername.domain.com:1433 of type 10
After following the instructions in the following article,
I found the 2 accounts that were suing the same SPN: they
were the "sa" account and the "administrator" account. I
don't think either of these should be deleted so how do
you fix this problem? What harm is caused by letting it go
on?
Thanks.
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;305971Hi joh,
Try to reassign SPN with SETSPN.EXE utility which is available for download
with win2000 resource kit
Regards,
Daniel
"joh" <anonymous@.discussions.microsoft.com> wrote in message
news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
> Hi All,
> Sorry to cross-post, but after looking through the
> subjects, I thought my question belonged more in this
> group.
> My SQL server keeps logging this error;
> Event ID 11 Source KDC: There are multiple accounts with
> name MSSQLSvc/servername.domain.com:1433 of type 10
> After following the instructions in the following article,
> I found the 2 accounts that were suing the same SPN: they
> were the "sa" account and the "administrator" account. I
> don't think either of these should be deleted so how do
> you fix this problem? What harm is caused by letting it go
> on?
> Thanks.
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;305971
>|||Thanks Daniel, I will give it a try.
joh
>--Original Message--
>Hi joh,
>Try to reassign SPN with SETSPN.EXE utility which is
available for download
>with win2000 resource kit
>Regards,
>Daniel
>"joh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
>> Hi All,
>> Sorry to cross-post, but after looking through the
>> subjects, I thought my question belonged more in this
>> group.
>> My SQL server keeps logging this error;
>> Event ID 11 Source KDC: There are multiple accounts with
>> name MSSQLSvc/servername.domain.com:1433 of type 10
>> After following the instructions in the following
article,
>> I found the 2 accounts that were suing the same SPN:
they
>> were the "sa" account and the "administrator" account. I
>> don't think either of these should be deleted so how do
>> you fix this problem? What harm is caused by letting it
go
>> on?
>> Thanks.
>> http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;305971
>
>.
>