Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniPelayar ini tidak lagi disokong.
Naik taraf kepada Microsoft Edge untuk memanfaatkan ciri, kemas kini keselamatan dan sokongan teknikal yang terkini.
Applies to:
SQL Server
To mirror a database that has a full-text catalog, use backup as usual to create a full database backup of the principal database, and then restore the backup to copy the database to the mirror server. For more information, see Prepare a Mirror Database for Mirroring (SQL Server).
In a newly created mirror database, the full-text catalog is the same as when the database was backed up. After database mirroring starts, any catalog-level changes that were made by DDL statements (CREATE FULLTEXT CATALOG, ALTER FULLTEXT CATALOG, DROP FULLTEXT CATALOG) are logged and sent to the mirror server to be replayed on the mirror database. However, index-level changes are not reproduced on the mirror database because it is not logged on to the principal server. Therefore, as the contents of the full-text catalog change on the principal database, the contents of the full-text catalog on the mirror database are unsynchronized.
After a failover, a full crawl of a full-text index on the new principal server might be required or useful in the following situations:
If change-tracking is turned OFF on a full text index, you must start a full crawl on that index by using the following statement:
ALTER FULLTEXT INDEX ON table_name START FULL POPULATION
If a full-text index is configured for automatic change tracking, the full-text index is automatically synchronized. However, synchronization slows full-text performance somewhat. If performance is too slow, you can cause a full crawl by setting change tracking off and then resetting it to automatic:
To set change tracking off:
ALTER FULLTEXT INDEX ON table_name SET CHANGE_TRACKING OFF
To set on automatic change tracking to automatic:
ALTER FULLTEXT INDEX ON table_name SET CHANGE_TRACKING AUTO
Nota
To see whether auto change tracking is on, you can use the OBJECTPROPERTYEX function to query the TableFullTextBackgroundUpdateIndexOn property of the table.
For more information, see ALTER FULLTEXT INDEX (Transact-SQL).
Nota
Starting a crawl after failover works the same as starting a crawl after a restore.
After service is forced to the mirror server (with possible data loss), start a full crawl. The method to use for starting a full crawl depends on whether the full-text index is change tracked. For more information, see "Full-Text Indexes After Failover," earlier in this topic.
ALTER FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
Database Mirroring (SQL Server)
Back Up and Restore Full-Text Catalogs and Indexes
Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniLatihan
Pensijilan
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Dokumentasi
Buffer Pool Extension - SQL Server
Learn about buffer pool extension and its benefits, which include improved I/O throughput. View best practices to follow when turning on this feature.
DBCC CLONEDATABASE (Transact-SQL) - SQL Server
DBCC CLONEDATABASE generates a schema-only clone of a database by using DBCC CLONEDATABASE in order to investigate performance issues related to the query optimizer.
Programming extended stored procedures - SQL Server
Learn about extended stored procedures in SQL Server, including how they work, and how to use them.