Re: SQL2005 fulltext backup

The pause just stops indexing not querying. Something else is going on to
stop the querying. Can you try to run repeated queries to verify exactly
where this occurs?

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



<johnsolver@xxxxxxxxx> wrote in message
news:1168346658.981384.250750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
    ... 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)