All geek questions in one place

Problem importing a database with SQL server

I have a database running in my local SQL Server 2005 express editor.

I need to import my local database into a remote server database.

To do this, I established a connection to this remote server, and now I can see this database. but when I tried to restore the database from my local machine, I get an error when I try to provide the location of the backup file. Below is the error message

EXECUTE permission was denied for the object 'xp_availablemedia', in the database 'mssqlsystemresource', schema 'sys'. The user does not have permission to perform this action. The application has been discontinued. (Microsoft SQL Server, Error: 229)

What is the problem, how can I solve it.

Please help me

+3
source share
2 answers

As the error indicates, the user connected to the database does not have the necessary rights to restore the database. If possible, grant backup rights by making the user a member of the db_backupoperator role.

sp_addrolemember 'db_backupoperator', 'user02'
+2
source

The user account you use to connect to the database does not have EXECUTE permission. This is necessary to perform recovery.

0
source

Source: https://habr.com/ru/post/1740906/

More articles:


All Articles