Re: SQL 2005 Failed to PAUSE\RESUME Errors

Is there any history to this server? Was it an upgrade? Does this apply?
http://support.microsoft.com/kb/923355/en-us

I had similar error myself and all I can do is a file group backup. I hate
to open a support incident and have Microsoft tell me to rebuild when my
configuration does not meet the description in this kb article.

--
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



"Woo" <Woo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35718597-0EAF-42FD-9777-883DE9ED6BFE@xxxxxxxxxxxxxxxx
Hiya,

I have several database on a SQL2005 server. They have fuill text
indexing
enabled. They all have one catalog referred to one table. Currently they
have not been populated so are therefore empty.

Problem is, everytime we do a backup of these databases it tries to PAUSE
and RESUME the full-text catalog but cant. There are the errors we get at
every backup of every database:

Changing the status to PAUSE for full-text catalog "KnowlegeBaseCatalog"
(5)
in database "INTERNATIONAL" (9). This is an informational message only. No
user action is required.

Warning: Failed to change the status to PAUSE for full-text catalog
"KnowlegeBaseCatalog" (5) in database "INTERNATIONAL" (9). Error:
0x8001010e(The application called an interface that was marshalled for a
different thread.).

Changing the status to RESUME for full-text catalog "KnowlegeBaseCatalog"
(5) in database "INTERNATIONAL" (9). This is an informational message
only.
No user action is required.

Warning: Failed to change the status to RESUME for full-text catalog
"KnowlegeBaseCatalog" (5) in database "INTERNATIONAL" (9). Error:
0x8001010e(The application called an interface that was marshalled for a
different thread.).


Any ideas?
Wendy


.

Relevant Pages

  • Re: SQL 2005 Failed to PAUSERESUME Errors
    ... Yes this server was upgraded from SQL2000 to SQL2005. ... I had similar error myself and all I can do is a file group backup. ... Director of Text Mining and Database Strategy ... They all have one catalog referred to one table. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: persistent full text catalog
    ... This is a bug related to moving / restoring FT-enabled databases to another ... server where the drive letter for the FT Catalogs is different than the ... -- Record new FT Catalog info. ... > I've a database in development environment that uses a full text catalog ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full-Text options disabled in management console
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... right click on the database "New Full-Text Catalog is grayed out/disabled. ...
    (microsoft.public.sqlserver.fulltext)
  • Full-Text options disabled in management console
    ... If I open a SQL 2000 database using the management console the Full-Text ... of SQL 2000 and on server editions installed on servers. ... right click on the database "New Full-Text Catalog is grayed out/disabled. ...
    (microsoft.public.sqlserver.fulltext)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
Loading