olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

backup support for SQL2022 with DDBoost EMC agent 19.13.0.44 #759

Closed ikflc closed 1 year ago

ikflc commented 1 year ago

Description of the issue

DDBoost backup failed for SQL2022 via the Ola backup script.

The direct call to dbo.emc_run_backup for SQL DB backup is running fine from the SQLAgent.

I am wondering if the Ola's script has been tested against the EMCAgent 19.13.0.44 on window 2019/SQL2022?

SQL Server version and edition Microsoft SQL Server 2022 (RTM-CU5) (KB5026806) - 16.0.4045.3 (X64) May 26 2023 12:52:08 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)

Version of the script Check the header of the stored procedure /*

SQL Server Maintenance Solution - SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, and SQL Server 2022

Backup: https://ola.hallengren.com/sql-server-backup.html Integrity Check: https://ola.hallengren.com/sql-server-integrity-check.html Index and Statistics Maintenance: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

License: https://ola.hallengren.com/license.html

GitHub: https://github.com/olahallengren/sql-server-maintenance-solution

Version: 2022-12-03 17:23:44

You can contact me by e-mail at ola@hallengren.com.

Ola Hallengren https://ola.hallengren.com

*/

What co What command are you executing?** EXECUTE [dbo].[DatabaseBackup] @Databases = 'SYSTEM_DATABASES' ,@BackupType = 'FULL' ,@CheckSum = 'Y' ,@BackupSoftware = 'DATA_DOMAIN_BOOST' ,@DataDomainBoostHost = ,@DataDomainBoostUser = ,@DataDomainBoostDevicePath = ,@DataDomainBoostLockboxPath = ,@CleanupTime = 48 ,@LogToTable = 'Y';

What output are you getting? Msg 50000, Sev 16, State 1, Line 1 : Error performing Data Domain Boost backup. [SQLSTATE 42000] Msg 0, Sev 16, State 1: [SQLSTATE 01000] Outcome: Failed [SQLSTATE 01000]

ikflc commented 1 year ago

User error due to typo