search

olahallengren / sql-server-maintenance-solution

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

Default Backup Location Folder doesn't exists #792

Closed heaivilin closed 9 months ago

heaivilin commented 9 months ago

Description of the issue Recently upgraded ola scripts via DBATools. In some of our instances our default backup location was configured to a folder location that didn't exist. This results in the job erroring, even when the @Directory variable is configured correctly. The default path needs to be updated before the job will succeed.

SQL Server version and edition Occurs on version 2016/17/19. Don't have others installed to try. All Enterprise.

Version of the script 2022-12-03 17:23:44

What command are you executing? All Full/Diff/Log standard backup jobs.
EXECUTE [dbo].[DatabaseBackup] @Databases = 'USER_DATABASES', @Directory = '\\BackupServer\SQLBackups\', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 48, @CheckSum = 'Y', @LogToTable = 'Y', @Compress = 'Y'

What output are you getting? The directory \\OldBackupServer\SQLBackups\ServerName\ does not exist. -- \OldBackupServer\SQLBackups\ServerName\ is set in the instance properties as the 'default backup location'

heaivilin commented 9 months ago

Closing this as I missed an obvious cause and once resolved, this wasn't an issue. This isn't a bug.