Re: SQL2005 fulltext backup

Hilary Cotter wrote:
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?

Hmm, I see, well the only queries that do fail (timeout actually, are
those containing FTS reference [CONTAINS etc.]), the only other
explanation I can think of is the fact that I backup to the same disk
the catalogs are on, would it be better to backup to a network
location?

Thanks.

--
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: Log Shipping In Syn?
    ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ... If there is some overlap you miss a scheduled backup, copy, ... If I set up the backup of the log file every 5 mins and I also setup ...
    (microsoft.public.sqlserver.replication)
  • 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)