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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.