question

NeerajTripathi avatar image
NeerajTripathi asked

Severity-16

Hi Experts, Since, we know that severity-16 alerts includes the database mirroring connection related errors and we are getting database mirroring errors a lot due to network fluctuation. Is there a way that we can only disable the mirroring related severity errors and exclude it from severity-16 and other errors will work as it is. I know we should work toward the network area but if we have anything to do in SQL. Please help. Thanks, Neeraj
mirroring
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sjimmo avatar image
sjimmo answered
You do not say what version of SQL Server you are working with. On SQL Server 2014 and above I use the following code: EXECUTE sp_altermessage , 'WITH_LOG', 'true'; GO To turn off the logging, change the true to a false.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

NeerajTripathi avatar image NeerajTripathi commented ·
No Sjimmo, This is not related to it. It is just if we want to log the errors in windows event log. THanks for answering.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.