SnapCenter Plug-in for SQL Server 无法使用文件流将数据库还原到备用主机
适用于
SnapCenter Plug-in for SQL Server 4.2.1 及更低版本
问题
SnapCenter Plug-in for SQL Server (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.