I'm trying to move the FileStream enabled DB from one server to another and got the following error:
Msg 3156, Level 16, State 6, Line 1
File 'FS_FILESTREAM' cannot be restored to 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\FS_FILESTREAM'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Could you please help?