A job that backs up many different databases is failing with the error below.
Executed as user: NT SERVICE\SQLSERVERAGENT. ...could not open backup file: (c:\db_backup\<server_name>.master.Full.<date>.SLS). The previous system message is the reason for the failure. [SQLSTATE 42000] (Error 60405)
We are running a script (that calls a LiteSpeed stored procedure 'master.dbo.xp_backup_database') from within SQL Server Management Studio UI, not from the LS console.
When we run this backup job from the LiteSpeed console UI, the same job runs successfully.
As a troubleshooting experiment, we changed the directory of where the backup files are being written to a different, then the backup job also ran successfully. .
