olahallengren / sql-server-maintenance-solution

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

backup failed when using @Directory = '/<dirname>' #696

Open wzcgh2019 opened 1 year ago

wzcgh2019 commented 1 year ago

Description of the issue backup failed when using @Directory = '/'

SQL Server version and edition Execute SELECT @@VERSION Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Linux (Oracle Linux Server 8.6)

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, and SQL Server 2019

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-01-02 13:58:13

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

Ola Hallengren https://ola.hallengren.com

*/ What command are you executing? EXECUTE DatabaseBackup @Databases = 'USER_DATABASES', @Directory = '/dbbackup', @BackupType = 'FULL' What output are you getting? Date and time: 2022-12-01 22:04:41 Server: o8 Version: 16.0.1000.6 Edition: Developer Edition (64-bit) Platform: Linux Procedure: [master].[dbo].[DatabaseBackup] Parameters: @Databases = 'USER_DATABASES', @Directory = '/dbbackup', @BackupType = 'FULL', @Verify = 'N', @CleanupTime = NULL, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'N', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @MinBackupSizeForMultipleFiles = NULL, @MaxFileSize = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTERBACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}{Partial}{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}{Partial}{CopyOnly}', @FileName = '{ServerName}${InstanceName}{DatabaseName}{BackupType}{Partial}{CopyOnly}{Year}{Month}{Day}{Hour}{Minute}{Second}{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${AvailabilityGroupName}{DatabaseName}{BackupType}{Partial}{CopyOnly}{Year}{Month}{Day}{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @FileExtensionFull = NULL, @FileExtensionDiff = NULL, @FileExtensionLog = NULL, @Init = 'N', @Format = 'N', @ObjectLevelRecoveryMap = 'N', @ExcludeLogShippedFromLogBackup = 'Y', @DirectoryCheck = 'Y', @StringDelimiter = ',', @DatabaseOrder = NULL... Version: 2022-01-02 13:58:13 Source: https://ola.hallengren.com

Msg 50000, Level 16, State 1, Procedure DatabaseBackup, Line 2276 [Batch Start Line 0] The value for the parameter @Directory is not supported.

Msg 50000, Level 16, State 1, Procedure DatabaseBackup, Line 2276 [Batch Start Line 0] The documentation is available at https://ola.hallengren.com/sql-server-backup.html.

Date and time: 2022-12-01 22:04:41

Completion time: 2022-12-01T22:04:15.8970000-05:00

wzcgh2019 commented 1 year ago

If adding a '/' after the directory name, such as, @Directory = '/dbbackup/', the backup command will complete successfully.