Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lisa_PG
Starting Member
2 Posts |
 Posted - 2006-04-27 : 09:30:34
|
| Hi all, I have moved hosting companies and am trying to get my website and MSSQL database sorted on the new server. I am using an enterprise type tool and can connect to the database the new hosting company has created on their SQL server with no problem. I now want to upload the data I had in the database previously. All I have to do this from is .BAK and .TRN files on my local hard drive. Using the restore option from the menu, I tried to select the .BAK file I have saved to restore from it, and got the following error:"EXECUTE permission denied on object 'xp_availablemedia', database 'master', owner 'dbo'."I also tried the advice given in this post as the problem seems similar and follows the same pattern: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40841 but there are loads of users listed for sp_who - it seems to be the users for all the databases on the host's server so I didn't follow the next step to disconnect them!Any advice as to what I need to do would be much appreciated.CheersLisa |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-04-27 : 09:37:53
|
| It looks like you don't have suitable permissions to restore the database. Maybe you need elevated permissions or someone else to restore your database for you. Would probably need database creator server role.Edited to add - This seems to be a limitation of Enterprise Manager rather than roles per se. If you have db_creator server role you can happily restore using query analyzer, but trying to restore in EM will give you this message.-------Moo. :) |
 |
|
|
lisa_PG
Starting Member
2 Posts |
Posted - 2006-04-27 : 10:41:57
|
| Thanks Mr Mist - at least it's not that I'm being completely dumb - I'll have to see if I can get the hosting provider to restore the database for me. Cheers |
|
|
|
|
|
|
Restoring from local BAK onto remote server