Re: SQL 2005 Failed to PAUSE\RESUME Errors

I cant create a new database just now as it is production but we did restore
from a backup of one of the problem databases and the problem copied over.

Do you think it is something to do with the upgrade process?


"Hilary Cotter" wrote:

If you create a new database with a full text table in it does it give this
error when backing it up?

--
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:9D27A968-4551-4A9F-8E39-54808CC65912@xxxxxxxxxxxxxxxx
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: 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: Copying a database between servers
    ... In 2000 you can backup to an UNC path ... or a local drive and the same goes for the restore. ... backup the database and then restore it on the new server. ... >>> one SQL Server 7.0 database with 'select' access to another SQL ...
    (microsoft.public.sqlserver.tools)
  • 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)
  • 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)
Loading