Re: Backup failure due to full-text indexing

Actually I just realized we get this error message every time we do a
transaction log dump. This error seems to be a warning message more than
anything else.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Mickael Parisot" <mparisot@xxxxxxxxxxxxx> wrote in message
news:8134E131-74B5-4ACA-A2E4-9C3C9CF445A7@xxxxxxxxxxxxxxxx
SP1 is already applied on SQL Server 2005.
Displayed version number is 9.0.2047.
It is running on two cluster nodes (Windows Server 2003 R2 Enterprise x64
Edition).

"Hilary Cotter" wrote:

IIRC, this is solved in SP1.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Mickael Parisot" <mparisot@xxxxxxxxxxxxx> wrote in message
news:21D9ED05-21D8-44F2-961E-1D5B4CAF4796@xxxxxxxxxxxxxxxx
Hi,
Sometimes, I got the following error while trying to perform a database
backup.
This backup is done on a regular basis using a maintenance plan.
There is a full-text catalog in the database and there must be a
conflict
somewhere.
Any idea?

------------

Date 14/09/2006 08:00:11
Journal Windows NT (Application)

Source MSSQL$BOL_PROD
Catégorie Server
Événement 3221229105
Utilisateur BRSAS\frbthhqisql36.sql
Ordinateur FRBTHHQISQL36

Message
The operating system returned the error '32(The process cannot access
the
file because it is being used by another process.)' while attempting
'CreateFile' on
'J:\BOL_PROD_DATA\MSSQL.4\MSSQL\FTData\Bihr_FullTextCatalog\SQL.HDR' at
'fulltext.cpp'(529).





.

Relevant Pages

  • Re: Invalid Descriptor Index
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Backup failure due to full-text indexing
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Shift the backup log after backup database (it was starting at the same ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: sp_addarticle without re-creating entire new snapshot
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... "Hilary Cotter" wrote: ... Use Paul ...
    (microsoft.public.sqlserver.replication)
  • Re: Fulltext and cluster - odd problem
    ... Hilary Cotter ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... [Location of errorlog files] ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Web Synchronization over HTTPS fails
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" skrev: ...
    (microsoft.public.sqlserver.replication)
Loading