0

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?

1 Answer 1

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.