MSSQL database backups are not created on the network location

Created:

2016-11-16 12:48:06 UTC

Modified:

2017-04-24 12:11:17 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MSSQL database backups are not created on the network location

Applicable to:

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

Symptoms

MSSQL database backups are not created on the network location specified in the settings:

The directory is left empty, and the backup is placed in its default location: %plesk_dir%\\Backup\\domain.tld\\databases\\admin_remote

Cause

The "Temporary network directory" on the above picture is used for keeping temporary(!) files. MSSQL database backup/restore uses this network share not as storage for backups, but as a temporary location to transfer the files between the PP and the remote MSSQL server:

1) When a backup is chosen for restoration and the temporary network directory is set up, the backup is copied to this folder and MSSQL is commanded to restore it. After that, the file on the network share is removed.

2) Backups are done similarly - MSSQL is commanded to backup to a network share, then the file is copied to the local repository and removed from the network share.

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