December 1, 2005 at 11:03 pm
Dear All
I am trying to export the data from the live SQL Server to my local SQL Server, however, I am getting "Failed to copy objects from SQL server to SQL Server".
I managed to export the stored procs by generating a script, and also to export the tables, however they did not have any relationships.
Do you have any idea what I can do?
December 2, 2005 at 2:40 am
You're trying to export all data and all objects? Why not just backup/restore?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 2, 2005 at 3:26 pm
When I tried to back up from the live server to my hard drive, its not allowing me, giving me "Execute Permission Denied on object 'xp_availablemedia', database 'master', owner 'dbo'"
December 2, 2005 at 3:29 pm
When I tried to back up from the live server to my hard drive, its not allowing me, giving me "Execute Permission Denied on object 'xp_availablemedia', database 'master', owner 'dbo'"
December 4, 2005 at 12:53 pm
Not 100% sure what that error message means - sounds like a security problem - perhaps the server doesn't have the right privileges to write to your PC. Are you able to do the backup on the server and then just use Explorer to copy the backup file to your PC and then restore?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 4, 2005 at 3:15 pm
I solved it
What I did was I created the same owner on my local database and it worked perfectly
Thanks for your help mate
Johann
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply