Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Fulltext process prevents backups completing

 
   Database Forums (Home) -> Full Text RSS
Next:  Can a dropped table be recovered?  
Author Message
Vinko

External


Since: Jun 11, 2008
Posts: 3



(Msg. 1) Posted: Fri Aug 01, 2008 4:36 am
Post subject: Fulltext process prevents backups completing
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

I have a few databases with full text index in spanish. Every time I
try to do a backup of these databases, be it through SSMS or a script,
full or filegroup, backups never finish until I kill or stop the full
text indexing service. Once I stop it the backup finishes correctly.

I thought that the filegroup backup did not back up full text indexes
and see no reason for the full text to hang the backup if it isn't
grabbing the index file...

How to debug/fix this?

Thanks,
Vinko.

 >> Stay informed about: Fulltext process prevents backups completing 
Back to top
Login to vote
Hilary Cotter3

External


Since: Aug 28, 2004
Posts: 1259



(Msg. 2) Posted: Sat Aug 02, 2008 9:31 pm
Post subject: Re: Fulltext process prevents backups completing [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I think you should open a case with CSS/PSS.

The full-text population should pause momentarily during the backup process,
but it should not cause either to hang.

"Vinko" wrote in message

>I have a few databases with full text index in spanish. Every time I
> try to do a backup of these databases, be it through SSMS or a script,
> full or filegroup, backups never finish until I kill or stop the full
> text indexing service. Once I stop it the backup finishes correctly.
>
> I thought that the filegroup backup did not back up full text indexes
> and see no reason for the full text to hang the backup if it isn't
> grabbing the index file...
>
> How to debug/fix this?
>
> Thanks,
> Vinko.

 >> Stay informed about: Fulltext process prevents backups completing 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]