Install-DbaMaintenanceSolution @Checksum parameter is invalid on case sensitive instance

[Tisit]

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

Install-DbaMaintenanceSolution may use @CheckSum as parameter in the backup jobs. This is invalid on case sensitive collation. Correct is @Checksum (small s). See documentation:
https://ola.hallengren.com/sql-server-backup.html

To me it looks like replacing @CheckSum with @Checksum in the command code should be enough to fix this issue

Steps to Reproduce

#run against case senstive instance
Install-DbaMaintenanceSolution -InstallJobs -SqlInstance . -ReplaceExisting -LogToTable -CheckSum ForceOff

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

2.8

Other details or mentions

No response

What PowerShell host was used when producing this error

Windows PowerShell (powershell.exe)

PowerShell Host Version

Name Value

---

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

SQL Server Edition and Build number

should not matter. Issue is clearly with collation

.NET Framework Version

PSChildName Version

---

v2.0.50727 2.0.50727.4927
v3.0 3.0.30729.4926
Windows Communication Foundation 3.0.4506.4926
Windows Presentation Foundation 3.0.6920.4902
v3.5 3.5.30729.4926
Client 4.8.09037
Full 4.8.09037
Client 4.0.0.0

[andreasjordan]

@claude please have a look at this issue and provide a fix.

[claude]

Claude finished @andreasjordan's task in 2m 29s —— View job • claude/issue-10357-20260420-1859 • Create PR ➔

---

Fix for @CheckSum Case-Sensitivity Issue

Tasks:

• Analyze the issue
• Find the relevant file and code
• Apply the fix (@CheckSum → @Checksum)
• Commit and push changes

Summary

Fixed Install-DbaMaintenanceSolution to use @Checksum (lowercase 's') instead of @CheckSum in the SQL job step commands it generates. This matches Ola Hallengren's documented parameter name and resolves failures on case-sensitive SQL Server collations.

Changes in public/Install-DbaMaintenanceSolution.ps1:

• Lines 846–857: All @CheckSum references in regex patterns for ForceOn, ForceOff, and Remove modes updated to @Checksum
• Lines 109–111: Help documentation updated to match

The PowerShell parameter -CheckSum and variable $CheckSum were intentionally left unchanged — only the SQL stored procedure parameter @Checksum was corrected.

|