Read-DbaBackupHeader - SQL 2005 backup fails with column "CompressedBackupSize" does not belong to table

[dlh275]

Steps to Reproduce

Attempt to read backup information from a SQL 2005 backup. WSMELTON identified the code was removed here: 8f99181#diff-7240b60d2bff43b467f5dbf0a39e6bb7

<#
Get-DbaBackupInformation -Path 'Z:\Temp' -SqlInstance SQL05 -DatabaseName DB -MaintenanceSolution -IgnoreLogBackup
#>

Actual Behavior

WARNING: [11:26:45][Read-DbaBackupHeader] Problem found with Z:\Temp\SQL05\DIFF\db.bak. | Column 'CompressedBackupSize' does not belong to table
Table.

Environmental data

• PowerShell: 0.9.734
• • SQL Server: Microsoft SQL Server 2005

[wsmelton]

This is an easy one to fix and will try to get to this today. The initial code that addressed this issue was removed in a previous commit back in November....so just has to be put back in.

[wsmelton]

@potatoqualitee do you happen to have a 2005 version of pubs or northwnd we could add to our test so this bug does not come back again? Or do we want to include that level in our test?

[potatoqualitee]

sho do!

[potatoqualitee]

hows this looking, @wsmelton ?

[potatoqualitee]

info for me

[62.48 ms] C:\github\dbatools> Get-DbaBackupInformation -Path C:\temp\db1.bak -SqlInstance sql2005
WARNING: [21:00:30][Read-DbaBackupHeader] Problem found with C:\temp\db1.bak. | Column 'CompressedBackupSize' does not belong to table Table.