Wrong backup dates are shown or SQL Server Days Since Last Backup not working correctly after upgrade to 6.1.0.10 or 6.1.0.11 cartridges (4227278)

Incorrect backup dates are displayed or SQL Server Days Since Last Backup alarm is not working correctly after upgrade to 6.1.0.10 or 6.1.0.11 cartridges.

After upgrading the backup alarm fires incorrectly with backup software that uses the VSS backup service (e.g. Rubrik and Cohesity)

WORKAROUND

None

STATUS

Enhancement Request FOG-4044 was added to the SQL Server agent status properties beginning in the 6.1.2.10 and higher releases to count the vss copies as valid backups. This has been set as TRUE for newly added database agents.

To activate this configuration for agents created prior to the 6.1.2.10 cartridge.

1. Navigate to Administration | Agents | Agent Status
2. Select one or more of the SQL Server database agents
3. Click the Edit Properties button
4. Click the link to Modify the private properties of this agent
5. Under the vss copies as valid backup configuration field, set the Enable vss copies as valid backup as 1 (or 0 to disable vss copies being read as valid backups) 
   
6. Click the Save button to save the changes to the agent

Alternatively, run the following groovy script to change the Enable vss copies as valid backup setting for all SQL Server agents from False to True

srvConfig            = server["ConfigService"];
srvAgent             = server["AgentService"];

namespace = "DB_SQL_Server"
agentType = "DB_SQL_Server"

def updateASP(primaryASP) {
     primaryASP.setValueByString("considerVssCopies" , "1");
     srvConfig.saveConfig(primaryASP);
}

primaryASP = srvConfig.getAgentTypePrimaryAsp(namespace, agentType);
updateASP(primaryASP);
def allAgents = srvAgent.findByAdapterAndType("FglAM", "DB_SQL_Server");
allAgents.each {agent ->
     primaryASP = srvConfig.getAgentInstancePrimaryAsp(namespace, agentType, agent.getId());
     updateASP(primaryASP);
}

return true;

The following script checks the Error Log connection type setting for all SQL Server agents

def out = new StringBuilder();
def agentService = server.get("AgentService"); def configService = server.get("ConfigService"); def agents = agentService.findByAdapterAndType("FglAM", "DB_SQL_Server"); for (agent in agents) {
   def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
   if (primaryASP) {
      out.append(String.format("%s, %s: considerVssCopies=%s\n", agent.getRemoteClientId(), agent.getName(), primaryASP.getString("considerVssCopies")));
   }
}

return out.toString();