You Receive the Error 'BACKUP DATABASE permission denied in database' when Trying to Back Up Your Database Through the Plesk Control Panel.
Issue
You receive the following issue when attempting to backup your database through the Plesk Control Panel:
Error: dbbackup failed: Unable to backup database 'database' BACKUP DATABASE permission denied in database 'database'. BACKUP DATABASE is terminating abnormally. Cause: Your database user does not have permissions to backup its database.
Cause
This most commonly occurs because you built your site somewhere else, migrated it to our environment, and your former hosting provder had incorrect database settings.
Resolution
If you are on a shared hosting server open a ticket with the support department. If you are a dedicated server customer:
- Log into the server using Remote Desktop.
- Log into the Plesk Control Panel.
Plesk 12.5
- Go to Subscriptions > [Domain] > Databases (right sidebar). The primary user for the database will be the first user listed in the Users list.
- Open SQL Server Management Studio.
- Go to Server > Databases > [Database] > Security > Users.
- Select the primary database user. Right click and choose Properties.
- Under Owned Schemas and Membership select everything EXCEPT db_denydatareader, db_denydatawriter (&) guest.
- Click OK.
Plesk 12.0
- Go to Subscriptions > [Domain] > Website & Domains > Databases > Users One of the users listed will be in bold. This is the primary database user.
- Open SQL Server Management Studio.
- Go to Server > Databases > [Database] > Security > Users.
- Select the primary database user. Right click and choose Properties.
- Under Owned Schemas and Membership select everything EXCEPT db_denydatareader, db_denydatawriter (&) guest.
- Click OK.
Plesk 11
- Go to Subscriptions > [Domain] > Website & Domains > Databases > [Database] One of the users listed will be in bold. This is the primary database user.
- Open SQL Server Management Studio.
- Go to Server > Databases > [Database] > Security > Users.
- Select the primary database user. Right click and choose Properties.
- Under Owned Schemas and Membership select everything EXCEPT db_denydatareader, db_denydatawriter (&) guest.
- Click OK.
Plesk 9.5
- Go to Domains > [Domain] > Databases > [Database]. One of the users listed will be in bold. This is the primary database user.
You should now be able to backup your database through the Control Panel.
Article ID: 511, Created: April 10, 2012 at 7:38 AM, Modified: July 10, 2016 at 4:31 PM