Tuesday, 5 May 2020

database importing problem with sql server

https://stackoverflow.com/questions/2628753/database-importing-problem-with-sql-server


I have a database working in my local sql server 2005 express edition.
I have to import my local database to a remote server database.
For that i established connection to that remote server, and i can now see that database . but when i tried to restore database from my local machine i'm getting an error message when i tried to give backup file location. Below is the error message
The EXECUTE permission was denied on the object 'xp_availablemedia', database 'mssqlsystemresource', schema 'sys'. The user does not have permission to perform this action. The statement has been terminated. (Microsoft SQL Server, Error: 229)
what is the problem, how can i solve this.


As the error states, the user connected to the database does not have the required rights to do a database restore. If possible, grant backup rights by making the user a member of the db_backupoperator role.
sp_addrolemember 'db_backupoperator', 'user02'

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Blog Archive