Restoring database over existing database and full-text catlog integrity

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
Yes, this should work fine.
Hilary Cotter
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
"Travis Nordrum" <tnordrum@.krollontrack.com> wrote in message
news:%23BH%23WEX9FHA.3048@.TK2MSFTNGP10.phx.gbl...
>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
>
|||Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ecSzEWf9FHA.3772@.TK2MSFTNGP10.phx.gbl...
> Yes, this should work fine.
> --
> Hilary Cotter
> 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
> "Travis Nordrum" <tnordrum@.krollontrack.com> wrote in message
> news:%23BH%23WEX9FHA.3048@.TK2MSFTNGP10.phx.gbl...
>