We are new to using clustered shared volumes and SQL Server 2016 Enterprise Edition.
When restoring SQL Server 2005 databases with full text search catalogs onto our new 2016 instance, we get the following SQL Server error:
Msg 7627, Level 16, State 1, Line 2
Cannot create the full-text catalog in the directoryC:\ClusterStorage\Volume2\SQLData\LogBook
for the clustered server. Only directories on a disk in the cluster group of the server can be used.
We have restored this same database to a SQL Server 2016 without issue using:
USE [master];
RESTORE DATABASE [MYDATABASE]
FROM DISK = N'\\BACKUPSERVER\BACKUPS\DATABASE\Database_backup_201805070600.bak'
WITH FILE = 1,
MOVE N'DatabaseData'
TO N'C:\ClusterStorage\Volume2\SQLData\Database.mdf',
MOVE N'DatabaseLog'
TO N'C:\ClusterStorage\Volume1\SQLTranLogs\Database_log.ldf',
MOVE N'sysft_LogBook'
TO N'C:\ClusterStorage\Volume2\SQLData\LogBook',
NOUNLOAD,
REPLACE,
STATS = 5;
Have any of you ran into this using clustered shared volume instead of just a plain volume?
Here are some shots of the setup on the cluster using CSVs.
Using the old method on shared volumes our dependencies looked like this example:
Now using clustered shared volumes which are using SMB they look like this: