Restoring database over existing database and full-text catlog integrity

Restoring database over existing database and full-text catlog integrity

Post by Travis Nor » Thu, 01 Dec 2005 14:44:09


I know that if you have to drop a full-text enable database and restore it,
you will have to rebuild the full-text indexes. My question is, if you have
a database where the data has not changed since your last backup and you
restore over top of the existing database, is the full-text index's
integrity okay?

I have recently restored a large full-text enabled database over top of an
existing one after an upgrade failed and the full-text appears to be intact.
I can run full-text searches. Does anyone know if there are any potential
issues? The table has about 28 million rows and the full-text rebuild would
take days so I am trying to avoid that.

Thanks,

~Travis
 
 
 

Restoring database over existing database and full-text catlog integrity

Post by Hilary Cot » Fri, 02 Dec 2005 06:32:05

Yes, this should work fine.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/

 
 
 

Restoring database over existing database and full-text catlog integrity

Post by Travis Nor » Sat, 03 Dec 2005 00:36:07

Thanks.