How to move the SQL Server Filestream folder (or db files) to a new location.
Posted by Sanjeev on 16 May 2019 01:36 PM
In this example we are assuming that the current Docsvault database path is C:\DVSB DATA and the file stream folder is located at C:\DVSB DATA\DVFStream
Please follow the steps below in specified order:
CREATE DATABASE [DVSB] ON
(FILENAME = N'C:\DVSB Data\DVSB.mdf' ), -- Path of mdf file
(FILENAME = N'C:\DVSB Data\DVSB_log.ldf' ), -- Path of ldf file
(FILENAME = N'D:\DVFStream' ) -- Path of file stream folder
After this your database is ready to use at the new locations.
Note: You may need to assign proper security to the DVFStream folder at the new location if required.