Article ID: 125850, created on Jun 11, 2015, last review on Jun 17, 2016

  • Applies to:
  • Plesk 12.5 for Windows
  • Plesk 12.0 for Windows


Unable to take domain backup for MSSQL database.

The following error can be found in the %plesk_dir%admin\logs\php_error.log file:

[2015-04-18 12:12:18] ERR [panel] Unable to backup database 'db_'
        Cannot open backup device 'C:\Program Files (x86)\Parallels\Plesk\Backup\\databases\example-182\123'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.

(Error code 21):
0: Database.php:487
        Db_Table_Row_Database->_executeDbBackupCommand(array, array)
1: Database.php:314
        Db_Table_Row_Database->backup(string 'C:\Program Files (x86)\Parallels\Plesk\Backup\\databases\example-182\123')
2: class.DbBackupManager.php:224
        DbBackupManager->Backup(string '123')
3: client.domain.dbbackup.create.php:82
        plesk__client__domain__dbbackup__create->accessItem(string 'POST', NULL null)
4: UIPointer.php:619
        UIPointer->access(string 'POST')
5: plesk.php:36


Insufficient permissions on the %plesk_dir%\Backup\ folder for the SQL service user.


Set full permissions on the %plesk_dir%\Backup\ folder for MSSQL user permanently:

  1. Edit %plesk_dir%etc\DiskSecurity\MssqlSecurity.xml adding this string to file:

    <Entries><Entry AccounType="1" Domain="NT Service" Account="MSSQL$MSSQLSERVER2012" Path="[PRODUCT_ROOT_D]" SubPath="Backup" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="FullAccess" EntryFlags="0"/><Entry AccounType="1" Domain="NT Service" Account="MSSQL$SQLEXPRESS" Path="[PRODUCT_ROOT_D]" SubPath="Backup" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="FullAccess" EntryFlags="0"/></Entries>

    where MSSQL$SQLEXPRESS is a user for SQL Sever service.

  2. Run Plesk Reconfigurator > Repair Plesk installation > Plesk File Security to fix other possible permissions issues.

The following articles can be useful:

#124430 How to customize permissions for Plesk users by "Disk Security"

#120430 MSSQL does not start: Access is denied while attempting to open or create the physical file tempdb.mdf.

Search Words

file upload in file manager ends with error

Operating system error 5(Access is denied.)

creating backup

restore database

permissions on backup folders being reset

Cannot open backup device Operating system error 5(Access is denied.)

Database Backup Repository

BACKUP DATABASE is terminating abnormally

backup for database in database backup repo fails

Cannot open backup device ''. Operating system error 5(Access is denied.).

Unable to backup database

no backup database sql

Cannot open backup device

Unable to backup database 'skischuledb'

ed7be2b984f9c27de1d2dc349dc19c6d 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8 8b661cab116c79dbe6c4ac5bbdf1c8cb

Email subscription for changes to this article
Save as PDF