Define Full-text indexing.
Full text search is achieved using Full text indexing in SQL Server. It enables full text queries against character based data. Searches can include words, phrases, multiples forms of a word/phrase etc. To allow this, full text indexes must be created for columns referenced in the queries. A full text index is made of word tokens derived from the indexed text.
Steps to implement full text indexing:- Create a full text catalog.
- Create full text index
- Create a list of noise words to ignore
- Create a thesaurus for the language being used.
Define Full-text indexing.
A full text index has an index of type FULL TEXT. Full text indexing can only done for CHAR, VARCHAR, or TEXT columns. Currently searching using FULL TEXT index is only available in MYISAM tables. The full text index can be specified while creating the table or altering the table.
For e.g.CREATE TABLE TEST_SAMPLE(notes TEXT, FULLTEXT(notes)) TYPE=MyISAM
For searching:SELECT * FROM TEST_SAMPLE WHERE MATCH(notes) AGAINST('test');
Define Log shipping.
Log shipping is the process of shipping or automatically sending the transaction log which is already backed up at the primary server, to the secondary server. Once the log is copied to the secondary server instance, it is restored. The log can be shipped from one primary server instance to multiple secondary server instances. Log shipping increases data availability because if the primary database becomes unavailable, any of the secondary databases can be brought online manually.
