Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. SCOM SQL alerts are created every hour on SQL secondary replica server if "Always On" for Monitoring server is set in Skype for Business Server 2019 and 2015

SCOM SQL alerts are created every hour on SQL secondary replica server if "Always On" for Monitoring server is set in Skype for Business Server 2019 and 2015

View products that this article applies to.

Symptoms

In Microsoft Skype for Business Server 2019 or Skype for Business Server 2015, if you set the SQL Always On Availability for the Monitoring server, the SCOM SQL alerts are generated every hour on the SQL secondary replica server.

↑ Back to the top

Resolution

To fix this issue, do the following steps:
  1. Install the July 2019 cumulative update 6.0.9319.559 for Skype for Business Server 2015, Core Components or install the December 2019 cumulative update 7.0.2046.151 for Skype for Business Server 2019, Core Components.
  2. Fail over the database to a secondary database.
  3. Run Install-CsDatabase -Update -SqlServerFqdn <SqlServerFqdn> -Configured Databases.
  4. Run step 3 by failing over the primary database to each secondary database one at a time.

↑ Back to the top

Keywords: CI103686, kbHotfixAuto, scom sql alerts created every hour on secondary replica server, kbqfe, kbfix, kb

↑ Back to the top

Article Info
Article ID : 4510851
Revision : 12
Created on : 12/3/2019
Published on : 12/3/2019
Exists online : False
Views : 313