Data Protection Advisor (DPA): Backup All Clients report is missing some Microsoft SQL instances

           

   Article Number:     537214                                   Article Version: 2     Article Type:    Break Fix 
   

 


Product:

 

Data Protection Advisor

 

Issue:

 

 

When running the DPA Backup All Clients report against Microsoft SQL servers not all of the individual SQL instances are returned in the report.  Several of the instances appear to be missing but there is a line in the report which is labeled as Mixed:   
   
    User-added image   
   
   
     
                                                           

 

 

Cause:

 

 

Data Protection Advisor is working as designed   
   
    For Microsoft SQL Servers the DPA Agent will collect information on all the separate instances which are running on each SQL Server.  Each of these instances will have there own name as provided by the SQL DBA.  Within all Microsoft SQL servers there is a default instance created which is named local.  Some SQL DBAs do not remove this local default instance.     
   
    The Backup All Client report uses the Extended Job Rollup Operator to group all the backups from one client into one line on the report.  For SQL Servers which have not removed or remained the default local instance this causes of these SQL Servers to be returned on one line as Mixed.
                                                           

 

 

Resolution:

 

 

The Backup All Clients report is working as designed.     
   
    Customers can customize this report to change the behavior if needed or engage Dell EMC Professional Services to provide a customized report which is more suitable.