DBCCResult is blank for Test-

[johnsterrett]

Verified issue does not already exist?

No, I did not search

What error did you receive?

I did some testing with Test-DbaLastBackup today and noticed that when I have a database with corruption, the result for DBCCResult is blank instead of something like failed. I documented my testing at https://procuresql.com/blog/2024/07/21/validate-your-sql-server-backups-made-easy/

Steps to Reproduce

Test-DbaLastBackup -SqlInstance $server -Database CorruptionChallenge8

Please confirm that you are running the most recent version of dbatools

2.1.21

Other details or mentions

See https://procuresql.com/blog/2024/07/21/validate-your-sql-server-backups-made-easy/ for more details on the testing.

What PowerShell host was used when producing this error

Windows PowerShell ISE (powershell_ise.exe)

PowerShell Host Version

Name Value

---

PSVersion 5.1.20348.1366
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.20348.1366
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

SQL Server Edition and Build number

Microsoft SQL Server 2022 (RTM-CU11) (KB5032679) - 16.0.4105.2 (X64) Nov 14 2023 18:33:19 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2022 Standard 10.0 (Build 20348: ) (Hypervisor)

.NET Framework Version

.NET Framework 4.8.4614.0