Suppress Backup Messages In Logs

Question

Suppress Backup Messages In Logs

RonMexico

Hall of Fame

Points: 3474
More actions
August 17, 2021 at 2:56 pm

#3920815
I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress completed notifications by enabling trace flag 3266. However, I'm still dealing with "backup passed" and "backup skipped" entries which quickly clutters the log when performing log backups every 10 minutes on dozens of databases. The messages look like this
```
Backup passed. BACKUP DATABASE [TestDB] level [LOG]
Backup skipped. BACKUP DATABASE [master] level [LOG]
```
Is there a way to suppress these as well?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27060 More actions · Answer 1

RonMexico wrote:

I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress completed notifications by enabling trace flag 3266. However, I'm still dealing with "backup passed" and "backup skipped" entries which quickly clutters the log when performing log backups every 10 minutes on dozens of databases. The messages look like this
Backup passed. BACKUP DATABASE [TestDB] level [LOG]
Backup skipped. BACKUP DATABASE [master] level [LOG]
Is there a way to suppress these as well?

Did you mean 3226?

I have never seen that message in a SQL log. Are you using a third party backup?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

RonMexico Hall of Fame Points: 3474 More actions · Answer 2

Yes, 3226. My bad on the typo.

It is a third party backup which I've looked at their documentation to see if there is a setting to prevent writing to the SQL logs and that does not appear to be the case. I was trying to keep this from turning into troubleshooting the third party software which I why I didn't bring it up. I was hoping that since 3226 suppressed the completion messages that there was something similar for the other two. If not, then no big deal.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

RonMexico wrote:

Yes, 3226. My bad on the typo.
It is a third party backup which I've looked at their documentation to see if there is a setting to prevent writing to the SQL logs and that does not appear to be the case. I was trying to keep this from turning into troubleshooting the third party software which I why I didn't bring it up. I was hoping that since 3226 suppressed the completion messages that there was something similar for the other two. If not, then no big deal.

I agree with Michael... the messages being produced don't appear to be from SQL Server. I totally understand why you'd like to avoid 3rd party support but this one is going to need it unless you can find some setting/configuration in the 3rd party app.

Out of basic curiosity, what is the 3rd party app?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RonMexico Hall of Fame Points: 3474 More actions · Answer 4

RonMexico

Hall of Fame

Points: 3474

August 18, 2021 at 2:33 pm

#3921400

It is Dell Data Domain Boost

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 5

RonMexico wrote:

It is Dell Data Domain Boost

Thanks, Ron.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Michael L John One Orange Chip Points: 27060 More actions · Answer 6

RonMexico wrote:

It is Dell Data Domain Boost

Have you done test restores from this? We looked into this a while back, and they could not prove to me that their backup solution would have no data loss.

They may have added an agent, and Dell partnered with Ola Hallengren to add the Dell Domain Boost as an option to his backup solution.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

RonMexico Hall of Fame Points: 3474 More actions · Answer 7

We've done quite a bit of testing and so far so good with no data loss. Let's hope that continues to be the case.

Tuan Nguyen SSC Rookie Points: 27 More actions · Answer 8

Hi Ron, do you have any updates on this issue? We just implement DDBoost in our SQL environment and the SQL logs are flooded with this type of message. We contact DELL support and they point finger to Microsoft.