When is too much success a bad thing?

re: When is too much success a bad thing?

Adam Machanic — Tue, 30 Oct 2007 23:07:19 GMT

This customer? :)

http://sqlblog.com/blogs/andrew_kelly/archive/2007/10/29/successful-backup-messages-no-more.aspx

re: When is too much success a bad thing?

Najm — Wed, 07 Nov 2007 19:54:16 GMT

Adam,

It seems like a undocumented trace flag. I could not find it in BOL. Are there any other usefull flags that can be used but are not available in BOL.

Thanks.

Najm

re: When is too much success a bad thing?

kfarlee — Wed, 07 Nov 2007 20:51:02 GMT

This is a trace flag which has been in the product, but undocumented since SQL 2000. I'm currently in the process of getting it documented. It's just too useful and little to no risk.

re: When is too much success a bad thing?

TheSQLGuru — Sat, 24 Nov 2007 04:27:20 GMT

I SOOOO need this for one of my clients!! They have 6500+ databases on one server and the error log is essentially useless due to the number of 'backup successful' messages. I just tested this and fortunately it has no effect on the msdb tables, which I use for a home-grown log shipping system.