April 18, 2011 at 2:00 pm
Hi,
We are implementing full-text search (FTS) in our SQL-2008 applications, and I read somewhere that FTS is not supported on database snapshots.
We are using mirroring and snapshots as our D/R and reporting solution, so I would like to know what I should expect when we go live with FTS in our prod environment.
Will the FTS catalogs and indexes make it to the mirror?
Will they make it to the snapshot? (based on what I read, they will not)
What should be by D/R plan with regards to the FTS objects? Recreate them from scratch using deployment scripts?
Any insights into any of the above questions would be appreciated.
Thanks,
Marios
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 20, 2011 at 1:41 pm
According to the following link, I don't need to do anything on the full-text indexes on the mirror side (following failover), if auto-change tracking was already on in the principal server:
http://technet.microsoft.com/en-us/library/ms191182.aspx
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply