Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-12 : 08:31:24
|
| Keith writes "I have Sql Server 2k (sp2) running on NT 4.0 (sp6a). SS2K is setup to run transaction log backups for 6 databases every hour w/ integrity checks on the backups. I was wondering if there is a way to turn off successful (information) events in for the backups/integrity checks. I have tried searching through the microsoft newsgroups, your site (though I didn't go through the forum), a couple other Sql Server sites.. checked the books online, but if I still managed to ingore the obvious, when you make fun of me.. it better be funny :) I am almost ready to tell my boss that no one knows how because no one worrys about trying to elimnate good news. Thanx for any help.." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-12 : 11:32:41
|
| I've tried to do this as well by turning logging of for that error message sp_altermessage 18265, 'WITH_LOG', 'false'However this has no effect - I think its hardcoded into the backup command. A dblevel of 128 in sysmessages indicates that the error should be logged however after running the above command which sets it to 0 the log backups still show up in the application logHTHJasper Smith |
 |
|
|
|
|
|
NT Application Event Log vs SQL Server Events