Re: SQL2005 fulltext backup

the added IO will definitely cause some performance degradation. I don't
recommend backing up over a network.

Can you limit your queries to the top n by using containstable? This will
offer the best performance increase.

--
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:1168416703.603171.52210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • Re: Query messed up by relationship change?
    ... make a copy of your backup backend database, ... and make a copy of your "live" backend database (after everyone is out of it ... run append queries to copy all data from the linked live db tables into ...
    (microsoft.public.access.tablesdbdesign)