无法还原数据库 [英] Unable restore database

问题描述

我想通过sql server management studio从文件中恢复数据库（任务 - >恢复 - >数据库。我从设备中选择并选择文件）。之后我收到此错误：

i want to restore database from file(Tasks->Restore->Database. atrer i select from device and select file) via sql server management studio. After that i get this error:

The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XXXXXX.mdf'. Msg 3156, Level 16, State 8, Server XXXX, Line 2

如何弄清楚这个问题？这是安全错误吗？



SHOUTING删除 - OriginalGriff [/ edit]

how to figure out this problem? is it security error?

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

检查您的mdf文件'E：\Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \DATA \XXXXXX.mdf'位置。

Check your "mdf" file 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XXXXXX.mdf' location.

必须是服务器的权限问题。

检查您是否有权访问数据库引用的服务器。

It must be permission problems with your server.
Check if you have access to the server your database refers to.

检查权限和Services.msi

Check permissions and Services.msi

这篇关于无法还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！