Re: Backup failure due to full-text indexing

Thank you for your replies!
There is another error message in the maintenance plan history I didn't see
before.
It seems that the fulltext catalog is offline sometimes which would explain
why the backup could not be done.
But what could turn off the fulltext catalog?

Executing the query "BACKUP DATABASE [BihrOnline2_commerce] TO DISK =
N'K:\\BOL_BACKUPS\\BihrOnline2_commerce\\BihrOnline2_commerce_backup_200609141600.bak'
WITH NOFORMAT, NOINIT, NAME = N'BihrOnline2_commerce_backup_20060914160012',
SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "The
backup of the file or filegroup "sysft_Bihr_FTC" is not permitted because it
is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
to restrict the selection to include only online data. BACKUP DATABASE is
terminating abnormally.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.

"Hilary Cotter" wrote:

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: Backup failure due to full-text indexing
    ... Shift the backup log after backup database (it was starting at the same ... Run filemon to check which process is accessing the fulltext catalog ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Backup failure due to full-text indexing
    ... Rebuilding the fulltext catalog everytime, just before the "backup ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.fulltext)
  • Re: why is the SQL backup filesize so big
    ... Can we see your backup statement? ... Director of Text Mining and Database Strategy ... Anyone has any idea why is my database backup filesize so big. ...
    (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. ... This backup is done on a regular basis using a maintenance plan. ...
    (microsoft.public.sqlserver.fulltext)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
Loading