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: 405
sqlserver2005
|import
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