Friday, February 24, 2012

log shipping and Full text indexing

We have FT Indexing service enabled ? How do I know if we have any full text
indexes and when I log ship and/or backup my databases in SQL 2005, does it
take care of it as well or do I have to manually move them to the other
server and back them up ?
Using SQL 2005
ThanksOn your database, go to Storage and Full Text Catalogs. See if you have any
full text catalogs there.
A full database backup also takes care of backing up your full text
catalogs. Since log shipping uses a database backup to initialize the
secondary database, the full text catalog is restored as well on this
database.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:

> We have FT Indexing service enabled ? How do I know if we have any full te
xt
> indexes and when I log ship and/or backup my databases in SQL 2005, does i
t
> take care of it as well or do I have to manually move them to the other
> server and back them up ?
> Using SQL 2005
> Thanks
>|||On your database, go to Storage and Full Text Catalogs. See if you have any
full text catalogs there.
A full database backup also takes care of backing up your full text
catalogs. Since log shipping uses a database backup to initialize the
secondary database, the full text catalog is restored as well on this
database.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:

> We have FT Indexing service enabled ? How do I know if we have any full te
xt
> indexes and when I log ship and/or backup my databases in SQL 2005, does i
t
> take care of it as well or do I have to manually move them to the other
> server and back them up ?
> Using SQL 2005
> Thanks
>

No comments:

Post a Comment