myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Cannot restore database with fulltext index Options · View
Dolphyn
Posted: Wednesday, March 03, 2010 10:38:01 PM
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.
elian
Posted: Thursday, March 04, 2010 3:51:31 AM

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.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.