在sql server 2005中恢复数据库时无法保护备份文件。 。 。 。 。 。 [英] Not able to bowse backup file while restoring a database in sql server 2005 . . . . . .

问题描述

最近我要求为指定的数据库创建仅备份和恢复的登录，所以我创建了这样的登录。但在这里我遇到了一个问题，即在进行备份时我无法浏览备份位置而无法在恢复数据库时浏览备份文件。

通过命令备份和恢复工作正常。 />


浏览备份位置时出现此错误

Hi,

Recently i got a requirement to create a login for only backup and restore for specified databases, so i have created a login like that. But here i am facing an issue i.e. while taking backup i not able to browse the backup location and not able to browse backup file while restoring a database.
Through command backup and restore is working fine.

I am getting this error while browsing for backup location

TITLE: Locate Database Files - TESTSVR\GTUNEW
------------------------------

C:\Program Files\Microsoft SQL Server\MSSQL.56\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

------------------------------
BUTTONS:

OK
------------------------------

恢复数据库时出错

Error for restoring a database

TITLE: Locate Backup File - TESTSVR\GTUNEW
------------------------------

C:\Program Files\Microsoft SQL Server\MSSQL.56\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

------------------------------
BUTTONS:

OK
------------------------------

请建议我这个，我试过所有谷歌和其他网站可能的答案，但我不能。







Regard'd，

Thrilok。

please suggest me regarding this, i have tried all possible answers from google and other sites but i couldn't.



Regard'd,
Thrilok.

推荐答案

只有sysadmin才能查看windows路径。 。 。 。除了系统管理员，没有人可以访问Windows路径。





Regard's，

Thrilok。

Only sysadmin only can view the windows path . . . . Except sysadmin right nobody can access the windows path.


Regard's,
Thrilok.

这篇关于在sql server 2005中恢复数据库时无法保护备份文件。 。 。 。 。 。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！