SQL2008集群TSM恢复失败

An exception occurred while executing a Transact-SQL statement or batch. Cannot use file 'C:\k2r\K2_Primary_1.ndf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'Primary_1' cannot be restored to 'C:\k2r\K2_Primary_1.ndf'. Use WITH MOVE to identify a valid location for the file.

Cannot use file 'C:\k2r\K2_FG_Server_1.ndf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'FG_Server_1' cannot be restored to 'C:\k2r\K2_FG_Server_1.ndf'. Use WITH MOVE to identify a valid location for the file.

Cannot use file 'C:\k2r\K2_FG_HostServer_1.ndf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'FG_HostServer_1' cannot be restored to 'C:\k2r\K2_FG_HostServer_1.ndf'. Use WITH MOVE to identify a valid location for the file.

Cannot use file 'C:\k2r\K2_FG_Identity_1.ndf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'FG_Identity_1' cannot be restored to 'C:\k2r\K2_FG_Identity_1.ndf'. Use WITH MOVE to identify a valid location for the file.

Cannot use file 'C:\k2r\K2_FG_SmartBroker_1.ndf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'FG_SmartBroker_1' cannot be restored to 'C:\k2r\K2_FG_SmartBroker_1.ndf'. Use WITH MOVE to identify a valid location for the file.

Cannot use file 'C:\k2r\K2_FG_ServerLog_1.ndf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'FG_ServerLog_1' cannot be restored to 'C:\k2r\K2_FG_ServerLog_1.ndf'. Use WITH MOVE to identify a valid location for the file.

Cannot use file 'C:\k2r\K2_log_1.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

File 'FG_log_1' cannot be restored to 'C:\k2r\K2_log_1.ldf'. Use WITH MOVE to identify a valid location for the file.

Problems were identified while planning for the RESTORE statement. Previous messages provide details.

RESTORE DATABASE is terminating abnormally.

Changed database context to 'master'. (HRESULT:0x80131501)

参与6

2同行回答

夜阑珊夜阑珊系统运维工程师联阳
SQL集群恢复的时候,一定要选择集群共享盘。本地盘,网络共享盘都没有权限创建数据库。显示全部

SQL集群恢复的时候,一定要选择集群共享盘。本地盘,网络共享盘都没有权限创建数据库。

收起
系统集成 · 2016-11-07
浏览2173
yujin2010goodyujin2010good系统工程师大型零售巨头
你这是sql server 2008 主从吗?还是微软集群?微软集群出问题麻烦解决向主上恢复还是从上?使用的什么账户?是管理员吗?显示全部

你这是sql server 2008 主从吗?还是微软集群?微软集群出问题麻烦解决

向主上恢复还是从上?

使用的什么账户?是管理员吗?

收起
互联网服务 · 2016-11-03
浏览2161
  • 谢谢回复,解决方法已经找到sql集群一定要使用集群共享盘来恢复数据库。
    2016-11-07

提问者

夜阑珊
系统运维工程师联阳
擅长领域: 备份存储数据安全

相关问题

相关资料

问题状态

  • 发布时间:2016-11-03
  • 关注会员:2 人
  • 问题浏览:3696
  • 最近回答:2016-11-07
  • X社区推广