Wrong backup dates are shown or SQL Server Days Since Last Backup not working correctly (4227278)

Incorrect backup dates are displayed or SQL Server Days Since Last Backup alarm is not working correctly

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

This is an expected result after fixing defect FOG-3502 where the SQL Server cartridge did not support VSS backups, only SQL Server backups.

An setting was added to the SQL Server agent status properties as part of enhancement FOG-4242 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 

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();