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|
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
Backups and restores based on snapshots are affected based on the extra catalog files that are included in the snapshot.
Article URL http://www.symantec.com/docs/HOWTO69823