After restore database, what happy with full-text catelogs?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chen - 14 Dec 2004 17:31 GMT

Hi,

I have CRM database that contains full-text catalogs. Someone delete rows by
mistake. I need restore this database to same server from last night backup,
after database restore, do I need manually active full-text indexes or it
will automatically enable since I restore database at same server?

If I need do manually active full-text indexes, where and what kind steps I
need perform?

Regards,
Chen

Reply to this Message

Hilary Cotter - 14 Dec 2004 17:35 GMT

You should run an incremental population.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html

> Hi,
>
[quoted text clipped - 11 lines]
> Regards,
> Chen

Reply to this Message

John Kane - 15 Dec 2004 02:40 GMT

Chen,
I would recommend that you run a Full Population as the restored database,
may not be current with your existing database in addition to the rows that
were deleted.

Also, if your table does not have a timestamp column and you start an
Incremental Population, then in fact a Full Population is executed and
furthermore, an Incremental Population often takes as long to run as a Full
Population as it needs to determine if any rows are deleted and this causes
the Incremental Population to take as long as the Full Population, even if
no changes have occurred.

Finally, depending upon your SQL Server version ( SELECT @@version ) and if
you are using SQL Server 2000, you can use "Change Tracking" with "Update
Index in Background" and once your database is restored, you may never have
to run an Incremental Population again!

Thanks,
John

> Hi,
>
[quoted text clipped - 8 lines]
> Regards,
> Chen

Reply to this Message