0

I have complete readonly access to a SQL Server Database. If I try to do a backup, I get the following message.

The EXECUTE permission was denied on the object 'xp_get_tape_devices', database 'mssqlsystemresource', schema 'sys'.

How can I take a backup and load this data into my local SQLServer Express Edition?

abhi
  • 3,082
  • 6
  • 47
  • 73

1 Answers1

0

You can't. That's the whole purpose of the SQL Server security model. Otherwise, any valid database user with read access would be able to backup a DB and restore it somewhere else in order to view sensitive data. The last thing anyone wants is users messing with the database engine.

Ask the DBA if you can obtain a copy, if permitted.

HardCode
  • 6,497
  • 4
  • 31
  • 54
  • In my previous experience with Oracle, I was able to use a tool to store all the data to csv files by exporting them. and then use the same tool to import them to a local database. I had just read permissions on the database. I suppose I could write a tool to do that, instead. – abhi Sep 13 '11 at 16:10