database importing problem with sql server

Posted by tibin mathew on Stack Overflow See other posts from Stack Overflow or by tibin mathew
Published on 2010-04-13T10:25:10Z Indexed on 2010/04/13 10:33 UTC
Read the original article Hit count: 408

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about sqlserver2005

Related posts about import