Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: Checksum parameter case needs to match in all backup jobs and backup stored procedure for case sensitive collation #895

Open
ParagTengshe-VWH opened this issue Feb 12, 2025 · 1 comment

Comments

@ParagTengshe-VWH
Copy link

Description of the issue
Case mismatch issue for Checksum parameter. I had to make sure to change CheckSum to Checksum in backup jobs for SQL Servers with SQL_Latin1_General_CP1_CS_AS or Latin1_General_BIN collations.
SQL Server version and edition
Microsoft SQL Server 2019 (RTM-CU11) (KB5003249) - 15.0.4138.2 (X64) May 27 2021 17:34:14 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)
Microsoft SQL Server 2016 (SP2-CU17) (KB5001092) - 13.0.5888.11 (X64) Mar 19 2021 19:41:38 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)
Version of the script
Version: 2025-02-09 21:23:12
What command are you executing?
All backup jobs
What output are you getting?
Executed as user: @Checksum is not a parameter for procedure DatabaseBackup. [SQLSTATE 42000] (Error 8145). The step failed.

@olahallengren
Copy link
Owner

@ParagTengshe-VWH, I am sorry for this issue. Please see #868.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants