适用于SQL Server的SnapCenter 插件无法将具有文件流的数据库还原到备用主机
适用场景
适用于SQL Server 4.2.1及更早版本的SnapCenter 插件
问题描述
由于以下错误、适用于SQL Server的SnapCenter 插件(SCSQL)无法将具有文件流的数据库还原到备用主机。
Failed to restore. Access to the path '<MOUNT_POINT_PATH>\<FILESTREAM_DIRECTORY_PATH>' is denied.
SCSQL作业日志(SMSQL_<JobID>.log)显示的错误如下例所示。
2019-11-18T01:42:09.9546717+00:00 DEBUG SmSql_120 PID=[10712] TID=[27] Checking if database [database] exists....
2019-11-18T01:42:09.9546717+00:00 DEBUG SmSql_120 PID=[10712] TID=[27] Update the target location of the database files
2019-11-18T01:42:09.9546717+00:00 DEBUG SmSql_120 PID=[10712] TID=[27] createClonedDatabase End
2019-11-18T01:42:09.9546717+00:00 ERROR SmSql_120 PID=[10712] TID=[27] Access to the path 'C:\scmnpt\mpdisk0004\FSG1\Test_FileStream' is denied.
2019-11-18T01:42:09.9546717+00:00 ERROR SmSql_120 PID=[10712] TID=[27] Failed to restore. Access to the path 'C:\scmnpt\mpdisk0004\FSG1\Test_FileStream' is denied.