跳转到主内容

NetApp_Insight_2020.png 

SCSQL restores database files to wrong destinations

Views:
2
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Plug-in for Microsoft SQL Server (SCSQL) 4.2.1P1
  • "Restore the database to an alternate host" option is selected
  • SQL Server database using FILESTREAM

Issue

  • SCSQL restores database files to wrong destinations if "filestream.hdr" exists in the specified destination path for FILESTREAM.
  • Although the restore job succeeds, the restored database is not accessible.
  • SCSQL job log (SmSql_<JobID>.log) shows an ERROR like the following example.

Example:

2020-06-23T07:46:14.3851496+00:00 ERROR SmSql_60 PID=[2692] TID=[1222] Exception in ModifydbFileListWithAlternatePaths: The file 'C:\MSSQL\USRetail_data\FSG1\Test_FileStream\filestream.hdr' already exists.

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support