472,110 Members | 2,180 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,110 software developers and data experts.

SQL Server 2005 : Piecemeal restore with fulltext index

Hi,

I have a problem restoring a Read-Only filegroup in a database.
I've restored the Read/Write filegroups first without any problem.

Then, I am able to recover Read-Only filegroups which do not contain fulltext indexes with the command :
RESTORE DATABASE GSM FILEGROUP = 'FG_RO_20080214' WITH RECOVERY

However, for filegroups containing FullText indexes (Fulltext indexes are in the same filegroup as data used for this index), I always get the following error :

Server: Msg 3149, Level 16, State 6, Line 1
The file or filegroup "sysft_CAT_SM_20080127" is not in a valid state for the "Recover Data Only" option to be used. Only secondary files in the OFFLINE or RECOVERY_PENDING state can be processed.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

If I'm looking at sys.database_files catalog view, I can see the following
name type_desc state_desc
--------------------- ----------- -----------------
sysft_CAT_MS_20080127 FULLTEXT RECOVERY_PENDING

Does anyone have an idea, please.

Thanks in advance
Patrick
Mar 26 '08 #1
0 948

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Phil Powell | last post: by
reply views Thread by Phil Powell | last post: by
reply views Thread by Jay | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.