I just restored a database backup and now the result of the function FileTableRootPath() is incorrect.
Where is the place that I can change to change the result of this function?
Below is a T-SQL example from the documentation:
ALTER DATABASE database_name
SET FILESTREAM ( NON_TRANSACTED_ACCESS = FULL, DIRECTORY_NAME = N'directory_name' );
Note the database must be locked exclusively for this operation.