X hits on this document

410 views

0 shares

0 downloads

0 comments

103 / 200

Using NetBackup for SQL Server Backing up and restoring the databases that contain full-text search catalogs (SQL Server 2005)

7

In the Source Client box, specify the private interface name.

8

Click OK.

A dialog box opens that shows the SQL Server backups of the SQL Host made on the private network interface.

9

Continue with the restore as normal.

Backing up and restoring the databases that contain full-text search catalogs (SQL Server 2005)

If your databases contain full-text search catalogs, then they are backed up with the databases and are restored as a part of the recovery process. Nevertheless, some information about full-text catalogs is provided in this section to help you to understand how the backup and restore processes work.

Full-text catalog directory structure

A full-text catalog consists of a root directory, subdirectories, and dozens of files. SQL Server names the root full-text directory that is based on the directory name the end user gives. Typically, the directory name is the same as the index name, but SQL Server may alter if there are name conflicts. For example, consider if there is a full-text catalog named ‘cats’ for database ONE. Then a user creates a second database named ‘cats’ for database TWO. SQL Server creates a root full-text directory named ‘cats0000’ for the second full-text catalog.

SQL Server also creates a logical file to contain full-text catalogs. The logical file is named as sysft_full-text catalog name. For example, in the previous

103

Document info
Document views410
Page views410
Page last viewedSat Dec 03 16:28:42 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments