Backing up and restoring the databases that contain full-text catalogs
| Article:HOWTO69823 | | | Created: 2012-02-07 | | | Updated: 2013-03-02 | | | 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.
See About full-text catalog directory structure
|
|
Legacy ID
v14766123_v71360690
Article URL http://www.symantec.com/docs/HOWTO69823
Terms of use for this information are found in Legal Notices
Thank you.