|Article Number: 537214||Article Version: 2||Article Type: Break Fix|
Data Protection Advisor
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:
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.
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.