SQL2005 fulltext backup

Hi,
I have a maintenance plan on my production server that does full-backup
once every X days, the problem is that the DB is full-text enabled and
has some live catalogs, but it seems that while backup is running the
catalogs are offline which is unacceptable - checking the SQL log I
find these Lines:

**** Changing the status to PAUSE for full-text catalog .... etc.
for each catalog before backup and when the backup finishes:
**** Changing the status to RESUME for full-text catalog ... etc.

Is there any way to keep the FTS online during backup? (preferably
while still backing the catalogs)

Thanks.

.

Relevant Pages

  • Re: ICF Catalogs on SMS managed volumes
    ... I strongly concur with everything you said below about ICFRU, IDCAMS ... And while I like DFSMShsm, "leery" doesn't even begin to describe my ... feelings about using it as the primary backup and recovery tool. ... I am a little leery of letting DFHSM backup catalogs using EXPORT ...
    (bit.listserv.ibm-main)
  • Re: ICF Catalogs on SMS managed volumes
    ... CATALOG backup and recovery gets special attention ... I am a little leery of letting DFHSM backup catalogs using EXPORT ... what catalog backup and recovery tool your shop is using. ...
    (bit.listserv.ibm-main)
  • Re: SQL2005 fulltext backup
    ... Can you limit your queries to the top n by using containstable? ... Looking for a FAQ on Indexing Services/SQL FTS ... explanation I can think of is the fact that I backup to the same disk ... has some live catalogs, but it seems that while backup is running the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL2005 fulltext backup
    ... The pause just stops indexing not querying. ... but it seems that while backup is running the ... catalogs are offline which is unacceptable - checking the SQL log I ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL2005 fulltext backup
    ... Hilary Cotter wrote: ... Can you try to run repeated queries to verify exactly ... explanation I can think of is the fact that I backup to the same disk ... has some live catalogs, but it seems that while backup is running the ...
    (microsoft.public.sqlserver.fulltext)