-
Couldn't load subscription status.
- Fork 822
Description
When running Maintenance Solution Database Backup with IDERA SQLSafe backup, execution fails on a Named Instance.
Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5065222) - 15.0.4445.1 (X64) Aug 13 2025 11:07:18 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)
Version of the script
Version: 2025-08-23 17:25:24
What command are you executing?
EXECUTE dbo.DatabaseBackup
@databases = 'USER_DATABASES',
@Directory = 'D:\MSSQL\TransLog Backups',
@BackupType = 'LOG',
@Cleanuptime = 72,
@CleanupMode = 'BEFORE_BACKUP',
@backupsoftware = 'SQLSAFE',
@compress = 'Y',
@OverrideBackupPreference = 'Y',
@DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}',
@AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}',
@filename = '{DatabaseName}{BackupType}{Partial}{CopyOnly}{Year}{Month}{Day}{Hour}{Minute}{Second}{FileNumber}.{FileExtension}',
@AvailabilityGroupFileName = '{DatabaseName}{BackupType}{Partial}{CopyOnly}{Year}{Month}{Day}{Hour}{Minute}{Second}{FileNumber}.{FileExtension}',
@DatabasesInParallel = 'Y',
@verify = 'Y',
@Checksum = 'Y',
@LogToTable = 'Y'
What output are you getting?
Msg 0, Sev 16, State 1: xp_ss_backup did not complete. An error(0,1) was encountered. Please check the parameters and their values. [v9.4.0.93] SQLsafeCmd output: ------------------ SQLsafe Backup and Recovery CLI Version 9.4.0.93 (x64) Copyright (c) 2004-2025 Idera, Inc., All Rights Reserved. http://www.idera.com/ Connecting to service on TS-FLX-ODS01...success. (9.4.0.93) Connecting to SQL Server TS-FLX-ODS01...FAILED. A network-related or instance-specific error occurred while establishiOutcome: Failed [SQLSTATE 01000]
Windows Server name - TS-FLX-ODS01, SQL Server name - TS-FLX-ODS01\ODS