sql server 2008 还原数据库出错问题

[weixin_38055275]

在sql server 2008 （Microsoft SQL Server Enterprise Edition (64-bit)上还原数据库，该用户是该数据库的owner，server role是dbcreator和public。
如下图，点击“add”想打开路径的时候就报如下出错。
试过在另外一个测试环境里的sql 开发版上同样设置是可以成功的。
也试过如果赋予该用户sysadmin的时候可以成功打开设备路径。
请问问题出在哪里啊？
谢谢。

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The EXECUTE permission was denied on the object 'xp_availablemedia', database 'mssqlsystemresource', schema 'sys'.
The user does not have permission to perform this action.
The statement has been terminated. (Microsoft SQL Server, Error: 229)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

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

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