开发者

How to backup a [SQL Server] database if privileges are not present?

开发者 https://www.devze.com 2023-04-04 07:01 出处:网络
I have complete readonly access to a SQL Server Database. If I try to do a backup, I get the following message.

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?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消