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

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
You should run an incremental population.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:07AD58B8-128E-4726-8293-6E60198E5D3C@.microsoft.com...
> 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
|||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
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:07AD58B8-128E-4726-8293-6E60198E5D3C@.microsoft.com...
> 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