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 |
|
djj55
Constraint Violating Yak Guru
352 Posts |
 Posted - 2010-07-23 : 09:50:37
|
| Hello, I am getting event logs for my log shipping backup job even though I have no notifications checked. Is there a way to stop the message from being created? I would not mind if it were only on error but since log shipping occurs frequently it is annoying. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-23 : 10:58:14
|
| You can use trace flag 3226http://msdn.microsoft.com/en-us/library/ms188396.aspx"By default, every successful backup operation adds an entry in the SQL Server error log and in the system event log. If you create very frequent log backups, these success messages accumulate quickly, resulting in huge error logs in which finding other messages is problematic. With this trace flag, you can suppress these log entries. This is useful if you are running frequent log backups and if none of your scripts depend on those entries. " |
 |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2010-07-23 : 12:04:26
|
Thanks. I would think you would want to turn off something not turn on a trace.  |
|
|
|
|
|
|
Event Log creation from log shipping