Rank: Newbie Groups: Member
Joined: 3/3/2010 Posts: 1 Points: 3 Location: California
|
Hi,
Using the Restore Wizard (Web Hosting), I cannot restore a database that includes a fulltext index.
The restore fails with an error like this: File 'E:\SQL\MSSQL.1\MSSQL\Data\dbname_log.LDF' is claimed by 'sysft_dbname-ft'(65537) and 'dbname_log'(2). The WITH MOVE clause can be used to relocate one or more files. File 'E:\SQL\MSSQL.1\MSSQL\Data\dbname_log.LDF' is claimed by 'sysft_dbname-ft2'(65538) and 'dbname_log'(2). The WITH MOVE clause can be used to relocate one or more files. RESTORE DATABASE is terminating abnormally.
This caused me some grief because the database I used to test the Restore Wizard is the same one that I previously used to test fulltext indexes. :(
Very few databases on our server use a fulltext index, but I thought I should post this information in case anyone runs into the same problem.
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
I'm sorry FTC are not currently supported by the restore feature.
|