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: 17055 - Backups fail 3041

Backups fail to create on local disk or get to ~75MB in
size and fail. 4.5GB free. DB is ~500MB. Error in
Application log is:
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE
[MSDS] TO DISK = N'C:\DATA\MSSQL\MSSQL$SQLP05
\BACKUP\MSDS_db_200408241628.BAK' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
Any input would be great. Thanks.I get the same error if there is not enough space left for backup on the
disk drives.
When you say 500Mb is that the file size or the data size?
Regards
Jonas
"I'm a server guy...not an SQL guy!" <anonymous@.discussions.microsoft.com>
wrote in message news:570e01c48a33$146e3ab0$a301280a@.phx.gbl...
> Backups fail to create on local disk or get to ~75MB in
> size and fail. 4.5GB free. DB is ~500MB. Error in
> Application log is:
> Description:
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE
> [MSDS] TO DISK = N'C:\DATA\MSSQL\MSSQL$SQLP05
> \BACKUP\MSDS_db_200408241628.BAK' WITH INIT ,
> NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> Any input would be great. Thanks.|||Jonas,
It is the size of the DB file.
>--Original Message--
>I get the same error if there is not enough space left
for backup on the
>disk drives.
>When you say 500Mb is that the file size or the data
size?
>Regards
>Jonas
>"I'm a server guy...not an SQL guy!"
<anonymous@.discussions.microsoft.com>
>wrote in message news:570e01c48a33$146e3ab0
$a301280a@.phx.gbl...
>> Backups fail to create on local disk or get to ~75MB in
>> size and fail. 4.5GB free. DB is ~500MB. Error in
>> Application log is:
>> Description:
>> 3041 :
>> BACKUP failed to complete the command BACKUP DATABASE
>> [MSDS] TO DISK = N'C:\DATA\MSSQL\MSSQL$SQLP05
>> \BACKUP\MSDS_db_200408241628.BAK' WITH INIT ,
>> NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
>> Any input would be great. Thanks.
>
>.
>|||Attached is what BOL have to say:
Error 3041
Severity Level 16
Message Text
BACKUP failed to complete the command %.*ls
Explanation
This error indicates that Microsoft® SQL ServerT could not complete the
BACKUP of the specified database due to a previous error. The BACKUP command
that failed is given at the end of the error message. This message also
appears in the Microsoft Windows NT® application log.
Action
To determine why the BACKUP failed, examine the Microsoft SQL Server error
log for any errors prior to error 3041.
Regards
Jonas
<anonymous@.discussions.microsoft.com> wrote in message
news:ccb901c48a76$1f545110$a401280a@.phx.gbl...
> Jonas,
> It is the size of the DB file.
>
> >--Original Message--
> >I get the same error if there is not enough space left
> for backup on the
> >disk drives.
> >
> >When you say 500Mb is that the file size or the data
> size?
> >
> >Regards
> >Jonas
> >
> >"I'm a server guy...not an SQL guy!"
> <anonymous@.discussions.microsoft.com>
> >wrote in message news:570e01c48a33$146e3ab0
> $a301280a@.phx.gbl...
> >> Backups fail to create on local disk or get to ~75MB in
> >> size and fail. 4.5GB free. DB is ~500MB. Error in
> >> Application log is:
> >> Description:
> >> 3041 :
> >> BACKUP failed to complete the command BACKUP DATABASE
> >> [MSDS] TO DISK = N'C:\DATA\MSSQL\MSSQL$SQLP05
> >> \BACKUP\MSDS_db_200408241628.BAK' WITH INIT ,
> >> NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> >>
> >> Any input would be great. Thanks.
> >
> >
> >.
> >