June 10, 2015 at 2:20 pm
Hi,
I am in the process of moving databases from a SQL 2005 Standard version to a 2-node 2014 cluster.
All of my 2005 databases back up successfully.
They all restore without issue except for one database that has a full text catalog. I get this message
Msg 7610, Level 16, State 1, Line 2
Access is denied to "\\fileStorage\data\MSSQLSERVER\FullTextCatalog", or the path is invalid.
Msg 3156, Level 16, State 50, Line 2
File 'sysft_FTCatalog' cannot be restored to '\\fileStorage\data\MSSQLSERVER\FullTextCatalog'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Here is my restore script. I have tried using SSMS with the same result.
USE [master]
RESTORE DATABASE [MyDatabase] FROM DISK = N'\\backups\servername.domain.local\MyDatabase_date_Full.BKP' WITH FILE = 1, REPLACE, MOVE N'MyDatabase_Data' TO N'\\fileStorage\data\MSSQLSERVER\MyDatabase_Data.MDF', MOVE N'MyDatabase_Log' TO N'\\fileStorage\logs\MSSQLSERVER\MyDatabase_Log.LDF', MOVE N'sysft_FullTextCatalog' TO N'\\fileStorage\data\MSSQLSERVER\FullTextCatalog', NOUNLOAD, STATS = 5
GO
I went as far as giving the folder full access to everyone temporarily and received the same error.
Any suggestions are more than welcome.
Thanks in advance for your help
June 11, 2015 at 4:11 am
FT catalog storage changed between SQL server 2005 and 2008, please see this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply