SQL 2005 DB restore with Full Text folders
I have been restoring some databases that have full text search files with them. I can change the path for the data and log files, but I am having trouble with the full text files. I am using the SQLBackup ver 5.2 GUI and want the files to be created in the following directory G:\Mssql\System\MSSQL.3\MSSQL\FTData. I try to change the path for the full text folder and the okay button stays grayed out when I select this path. Instead it keeps creating the folders in the data directory like the following G:\Mssql\Data1\ix_SSIQ_IDEM_Content. How can I get the full text folders to create in the proper FTData folder during the restore?