Skip to main content
NetApp Knowledge Base

SnapCenter Plug-in for SQL Server fails to restore database with filestream to alternate host

Views:
496
Visibility:
Internal
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

SnapCenter Plug-in for SQL Server 4.2.1 and older

Issue

 

SnapCenter Plug-in for SQL Server (SCSQL) fails to restore database with filestream to alternate host due to the following error.
 

Failed to restore. Access to the path '<MOUNT_POINT_PATH>\<FILESTREAM_DIRECTORY_PATH>' is denied.

QL Server fails


SCSQL job log (SmSql_<JobID>.log) shows errors like the following example.


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.

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

This is an internal KB article and its content should not be copy/pasted and shared with people outside of NetApp. Always seek Duty Manager authentication of caller for password reset requests. If you need further assistance post a question in Knowledge Xchange