Remote MS SQL backup failed

Created:

2016-11-16 13:03:50 UTC

Modified:

2017-04-24 11:34:10 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Remote MS SQL backup failed

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Backup of MS SQL database from remote MS SQL server cannot be made.

Failed with the error below:

Error: dbbackup failed: Unable to backup database 'db_name'
The backup device 'c:\\db_backup\ est_parallels' can not be opened. Operating system error 3 (The system can not find the path specified.).
BACKUP DATABASE is terminating abnormally.

or

Error: dbbackup failed: Unable to backup database 'db_name' Unable to open connection: A specified logon session does not exist. It may already have been terminated

or

Cannot dump database content 'db_name' of type 'mssql'
Error:
Login failed for user 'NT AUTHORITY\\ANONYMOUS LOGON'

Cause

Database backup settings are incorrect to access the remote MS SQL server.

Resolution

Ensure that the following requirements are met in the "Microsoft SQL Server database backup" settings:

  • Temporary directory: local path to the temporary backup folder on the MS SQL server.
  • Temporary network directory: UNC path to the temporary backup folder on the remote MS SQL server.
  • Username: network login to remote MS SQL server.

  • Temporary directory is shared and this location is specified in Temporary network directory

  • User specified in Username has Modify permission to Temporary directory share folder, sub-folders and files. If local account of MS SQL Server is used, server name prefix should be specified, as follows: "sqlservername\username"
  • Temporary directory: is accessible for user account that MS SQL server service can use to log on. You may find this user account name under "Log On" tab in MS SQL server service properties in Windows services.

Additional information can be found in 'Plesk Advanced Administration Guide'

for Plesk 11.5 , for Plesk 12

Have more questions? Submit a request
Please sign in to leave a comment.