Discussion:
Restore catalog after corruption ?
(too old to reply)
Vuillermet Jacques
2006-09-20 11:34:37 UTC
Permalink
Sometimes (about once a year) the catalog become corrupted.

Usully, I :
- stop the service cisvc ;
- delete the catalog folder ;
- and re-start the service cisvc, so IX re-indexes ALL the files.

But, now, I have about 70 000 files to index on remote shared folders : it's
spend a lot of time !

So, I'm asking to myself if it is possible to restore nigth backup of the
catalog folder.

Will the cisvc service will be able to find where to re-start the indexation
?

Is this operation reliable ?

Have you done it already ?

Thank you for your answers !

Jacques.
Hilary Cotter
2006-09-20 12:01:20 UTC
Permalink
No, you can't backup and restore catalogs.
--
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
Post by Vuillermet Jacques
Sometimes (about once a year) the catalog become corrupted.
- stop the service cisvc ;
- delete the catalog folder ;
- and re-start the service cisvc, so IX re-indexes ALL the files.
But, now, I have about 70 000 files to index on remote shared folders : it's
spend a lot of time !
So, I'm asking to myself if it is possible to restore nigth backup of the
catalog folder.
Will the cisvc service will be able to find where to re-start the indexation
?
Is this operation reliable ?
Have you done it already ?
Thank you for your answers !
Jacques.
Vuillermet Jacques
2006-09-20 12:13:54 UTC
Permalink
Thanks a lot !

Jacques.
Post by Hilary Cotter
No, you can't backup and restore catalogs.
--
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
Post by Vuillermet Jacques
Sometimes (about once a year) the catalog become corrupted.
- stop the service cisvc ;
- delete the catalog folder ;
- and re-start the service cisvc, so IX re-indexes ALL the files.
But, now, I have about 70 000 files to index on remote shared folders : it's
spend a lot of time !
So, I'm asking to myself if it is possible to restore nigth backup of the
catalog folder.
Will the cisvc service will be able to find where to re-start the indexation
?
Is this operation reliable ?
Have you done it already ?
Thank you for your answers !
Jacques.
Loading...