database importing problem with sql server
- by tibin mathew
Hi,
I have a database working in mu local sql server 2005 express edition.
I have to import my local dtabase to a remote servr database.
For that i established connection to that remote server, and i can now see that database . but when i tried to restore database fro 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)
waht is the problem, how can i solve this.
Please help me