ERROR: 'BACKUP DATABASE Permission Denied In Database' When Trying To Back Up Your Database Through the Plesk Control Panel.

Plesk Servers > SQL > MSSQL
Error 'BACKUP DATABASE Permission Denied In Database' When Trying To Back Up Your Database Through the Plesk Control Panel.

Issue
You recieve 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. This most commonly occurs because you built your site somewhere else, migrated it to our servers, and your former hosting provder had incorrect database settings.

Resolution
If you are on a shared hosting server, then issue must be resolved by a support technician. If you are a dedicated server client, you can perform the steps below to resolve the issue. If you are unsure of which version of Plesk Control Panel is controlling the web services of your server, see  How do I Determine What Version of Plesk Control Panel I am Using?

Identify the Primary Database User in Plesk 12
  1. Log into the server through Remote Desktop.
  2. In the Plesk Control Panel, go to Domains > [Domain] > Databases > Users
 
Identify the Primary Database User in Plesk 11
  1. Log into the server through Remote Desktop.
  2. In the Plesk Control Panel, go to Domains > [Domain] > Websites & Domains >  Databases > [Database]. One of the users listed will be in bold.  This is the primary database user.
Identify the Primary Database User in Plesk 9
  1. Log into the server through Remote Desktop
  2. In the Plesk Control Panel, go to Domains > [Domain] > Databases > [Database]. One of the users listed will be in bold. This is the primary database user.
Set the appropriate permissions in SQL Server Managment Studio
  1. Open the Start Menu, click on SQL Server Management Studio.
  2. Go to Server > Databases > [Database] > Security > Users.
  3. Select the primary database user.  Right click and choose Properties.
  4. Under Owned Schemas and Database Role Membership select everything EXCEPT: db_denydatareader db_denydatawriter guest
  5. Click OK.
 
 
 

Add Feedback