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 |
|
beanz
Starting Member
35 Posts |
 Posted - 2005-06-13 : 07:38:40
|
| Whenever our databases are backed up or the transaction logs are backed up an event is written to the Event log on the server.I have set the SQL job to only log an event when the job fails but it is logging on every success too.Does anyone know how I can turn this off??Cheers,Danny |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-14 : 19:18:03
|
| You can't. You can only turn off logging to the Event Viewer all together, not for only failures. If you don't want any information written to Event Viewer and only written to the SQL Server Error Log, you can add flags to your startup. Check SQL Server Books Online for details.Tara |
 |
|
|
beanz
Starting Member
35 Posts |
Posted - 2005-06-14 : 19:58:18
|
| Not quite the response I was hoping for!Thanks very much for getting back to me, much appreciated.Danny |
|
|
|
|
|
|
Turning Off Event Log Entries