I ha trying to restore a backed up SQL / CRM 3.0 database to new server hardware and have the following error on the MSCRM database.
Restore failed from server CRMSVR. (Microsoft.SQLServer.Smo)
System.Data.SqlClient.SQLError: The Path 'D:\SQLDATA\MSSQL.1\MSSQL\FTData\ftcat_documentindex' has invalid attributes. It needs to be a directory. It must not be hidden, read only, or a removable drive (Microsoft. sqlserver.smo)
The SQL database and install on the source server is on d: drive, and it is on c: drive on the destination server. I am assuming that there is something hard coded in this database that needs the same resore drive on the destination server but wanted to confirm this.
Is there any other way around this issue as I am trying to retire the old server and bring the new CRM server online.
I have also tried an import of the database and it gets to approximately 90 percent imported and fails also.