Regresar
-
Título
backup failed. Executed as user: NT SERVICE\SQLSERVERAGENT. ...could not open backup file: (c:\db_backup\.master.Full. .SLS) -
Descripción
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. .
-
Causa
The user that that the script is running under in the SQL Server Management Studio is lacking some required permission (read and write are required) on the backup directory.
The job runs successfully from the LiteSpeed console because it is running under a different user from the user (SQLSERVERAGENT) running the scripts from within SQL Server Management Studio. The user running from within the LiteSpeed console has full permissions on the directory to which the backups are going. -
Resolución
Give full permissions (including write) to the user (SQLSERVERAGENT, in this example) who is running that script.