January 27, 2014 at 10:29 am
I modified a table to change the datatype of a column to varchar from char. To do this, I had to drop and recreate the full text index on that column. All of that went OK.
I wanted to run my script again in my dev environment. I restored the database from a database snapshot, and after the restore, the entire full text catalog was gone, so it was not present on any tables, not just the one I changed. I repeated this several times, and got the same result each time. I also tried restoring from the snapshot without making any changes to the database, and got the same result with the entire full text catalog gone.
I guess the following says full-text indexes are not supported by database snapshots, but having the whole full-text catalog disappear after a restore from the snapshot was a surprise.
http://technet.microsoft.com/en-us/library/ms189940(v=sql.105).aspx
"Limitations and Requirements of Database Snapshots
...
Full-text indexing is not supported on database snapshots. Full-text catalogs are not propagated from the source database..."
Anyone else ever run into this? Is this still the same in SQL Server 2012?
August 3, 2017 at 4:08 am
Thanks for the link.
I ran into same problem. While restoring databases from snapshots the fullt-text-catalog was gone.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply