How to backup Full text indexes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SqlJunkies User - 23 Nov 2004 05:17 GMT

I have a full text index which took 20 hours to complete the full population. in case of a problem i don't want to repopulate if spending 20 hrs.

Is there a way to backup the Index File structure and resore it using a software like windows backup. Or just copy the file structure to a backup storage and restore it to the same place after restoring the database?

Thanks in Advance.

Reply to this Message

John Kane - 23 Nov 2004 06:51 GMT

SqlJunkies User,
There is no direct method of backing up the FT Catalog folder & files, and
restoring it like a windows backup as not only are there file backup issues
, but SQL Server and registry keys and values setting that need to be
maintained/altered. No, a straight file copy will not work, and you should
review the restrictions and procedures in KB article 240867 (Q240867) "INF:
How to Move, Copy, and Backup Full-Text Catalog Folders and Files" at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;24086

Regards,
John

> I have a full text index which took 20 hours to complete the full population. in case of a problem i don't want to repopulate if spending 20

hrs.

> Is there a way to backup the Index File structure and resore it using a software like windows backup. Or just copy the file structure to a backup

storage and restore it to the same place after restoring the database?

> Thanks in Advance.
>
> ---
> Posted using Wimdows.net NntpNews Component -
>
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Reply to this Message