Re: SQL 2005 Failed to PAUSE\RESUME Errors

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hiya,

Yes this server was upgraded from SQL2000 to SQL2005.

This article doesnt apply because my backup still works ok but it just fires
out this error message everytime.

I have one database on this server where the full text catalogs dont cause
any issues during backups. The rest of the databases all have this problem.

Also, I have another server that was upgraded in the same way and none of
the databases have this problem.

Any suggestions are most welcome!
Wendy




"Hilary Cotter" wrote:

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: 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)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • RE: Adventures in Server restore
    ... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)