Return
-
Title
backup failed. Executed as user: NT SERVICE\SQLSERVERAGENT. ...could not open backup file: (c:\db_backup\.master.Full. .SLS) -
Description
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. .
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.