メインコンテンツまでスキップ
Effective December 3 - NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources. For accounts that did not pre-register (prior to Dec 3) access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity. To learn more, Read the FAQ and Watch the video.

SCSQL restores database files to wrong destinations

Views:
14
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