Software Defect. This issue is being tracked as LS-2141: "Maintenance plan report formatting is incorrect"
Steps To Reproduce:
- Run a maintenance plan with maintenance plan reporting enabled.
- Review the MP report.
- Note MP report now list the “backup destination” twice.
Example.
good
LiteSpeed SlsSqlMaint Utility.
Logging on to SQL Server 'TWRWSQL0901' with Windows Authentication
Logged on to SQL Server 'TWRWSQL0901'
[1] Database "[DBAdmin]": Back Up Database 1 (twrwsql0901)..
Backup destination: N'\\nb\corp\Apps\sqldmp04_2\TWRWSQL0901\DBAdmin\DBAdmin_Full_2020-06-23-190701.bak'
[1] Execution Time: 0 hrs, 0 mins, 4 secs.
bad
Logging on to SQL Server 'TWRWSQL1313' with Windows Authentication
Logged on to SQL Server 'TWRWSQL1313'
[1] Database "[DBAdmin]": Back Up Database 1 (twrwsql1313)..
Backup destination: \\nb\corp\Apps\sqldmp04_2\TWRWSQL1313\DBAdmin\DBAdmin_Full_2020-06-23-213201.bak,N'\\nb\corp\Apps\sqldmp04_2\TWRWSQL1313\DBAdmin\DBAdmin_Full_2020-06-23-213201.bak'
[1] Execution Time: 0 hrs, 0 mins, 5 secs.
Expected Results: MP report should list the backup destination only once.