Backing up and restoring the databases that contain full-text catalogs

Article:HOWTO69823  |  Created: 2012-02-07  |  Updated: 2013-03-01  |  Article URL http://www.symantec.com/docs/HOWTO69823
Article Type
How To


Environment

Subject


Backing up and restoring the databases that contain full-text catalogs

When you back up a database that contains a full-text catalog, NetBackup writes the catalog name and directory path to NetBackup catalog. NetBackup for SQL Server displays the full-text catalog information in the backup history properties windows when you select the database backup image. If you choose to move the database, then the saved full-text catalog information allows NetBackup for SQL Server to generate specifications for the move template. In the move template, you can specify a path for the catalog directory.

Snapshot backups also include all of the files in any full-text catalog that is associated with the object that is backed up. This affects backups database, filegroup, and file backups as follows:

  • Database backup: The full-text catalog files are backed up with the full database snapshot backup.

  • Filegroup backup: The full-text catalog files are backed up for any catalog that is associated with the filegroup.

  • File backup: NetBackup for SQL Server backs up the full-text catalog files along with a snapshot file backup

    The backup is performed based on the following conditions:

    • The file belongs to a filegroup that is associated with a full-text catalog

    • The file has the lowest sort-order of any file that belongs to the filegroup.

Backups and restores based on snapshots are affected based on the extra catalog files that are included in the snapshot.

See About full-text catalog directory structure

See Moving a database that contains full-text catalogs

See Overview of using NetBackup for SQL Server


Legacy ID



v14766123_v71360690


Article URL http://www.symantec.com/docs/HOWTO69823


Terms of use for this information are found in Legal Notices