Plesk Backup Manager Shows the Error "Unable to backup database"


While trying to create a backup using Backup Manager in Plesk, you may encounter the following error.

~~~~~~~~~~~
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:\Parallels\Plesk\Backup\XXXXXXXXX.co.nz\databases\XXXXXXXXX-29\test'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.

(Error code 21)
~~~~~~~~~~~

This error occurs because when the file system permissions for the database engine access is not configured or is wrongly configured. The database engine services may not have permission of windows file system to the access the location where the database files are stored.    

In a Windows server, the backups are stored in C:\Parallels\Plesk\Backup. You can follow the below steps to apply necessary windows file system permission to C:\Parallels\Plesk\Backup folder

~~~~~~~~~~~
1. Right click on the folder C:\Parallels\Plesk\Backup.
2. Click Properties
3. Select Security
4. Click on Edit
5. Click on Add
6. In From this location field select your computer name.
7. In Enter the object names to select field enter NT SERVICE\MSSQLSERVER
8. Click on Check Names. This check often fails and might show the warning as the name was not found. When you click OK, a dialogue box showing Multiple Names Found appears.
9. Click OK to return to the Permissions dialogue box.
10. Under Group or user names, select (NT SERVICE\MSSQLSERVER). and then under Permissions for <user> select the allow check box for Full control.
11. Click OK twice to exit.  
~~~~~~~~~~~

Now you can rerun the backup task from Backup manager in Plesk panel.

Last update:
2016-06-03 16:52
Author:
Bytehouse Technical Support
Revision:
1.2
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.

Most popular FAQs RSS

  1. I require an additional IPv4 address. What is Bytehouse's ... (89488 views)
  2. The Most Common Problems When Migrating Websites (71398 views)
  3. How do I create a 301 redirect? (59283 views)
  4. Can I Backup Exchange 2010 with My Online Backup ... (55662 views)
  5. Steps to Add Administrator User for Windows Server (50557 views)

Latest FAQs RSS

  1. Steps to set/customize log rotation from plesk (2016-07-25 07:15)
  2. Generate a self-signed SSL certificate - Nginx,CentOS (2016-07-07 02:31)
  3. Procedure re-register Volume Shadow Copy Service(VSS) in a Windows ... (2016-07-05 04:18)
  4. Steps to Install Mcrypt in Plesk (2016-07-01 17:11)
  5. How to Retrieve a Plesk Password in Linux and ... (2016-07-01 17:09)

Regular new KB articles

Check back from time to time for new articles, or if you have any suggestions please feel free to recommend

top