Veritas NetBackup™ for Enterprise Vault™ Agent Administrator's Guide
- Introduction to NetBackup Enterprise Vault
- About NetBackup Enterprise Vault agent installation requirements
- Installation requirements for NetBackup Enterprise Vault agent
- Verifying Enterprise Vault agent operating system compatibility
- NetBackup server and client software requirements
- About Enterprise Vault agent installation requirements in a cluster
- Configuring Enterprise Vault Agent to protect Enterprise Vault databases
- Adding the Enterprise Vault agent license key
- Configuration requirements for upgrading the Enterprise Vault agent
- Configuration
- About the Windows and Java user interfaces
- Specifying a logon account for the Enterprise Vault server
- About VSS-based snapshot configuration
- Configuring the local media server for Enterprise Vault backup
- Configuration requirements for an Enterprise Vault backup policy
- Adding a new Enterprise Vault policy
- Enterprise Vault backup policy attributes
- Adding schedules to an Enterprise Vault policy
- About the types of Enterprise Vault backups
- Creating a backup selections list
- Adding a client to a policy
- About features provided by Enterprise Vault for a backup provider
- Performing backups of Enterprise Vault
- Performing restores of Enterprise Vault
- Important notes about Enterprise Vault data restore
- Stopping the administrative services on Enterprise Vault servers
- About the Backup, Archive, and Restore interface
- Viewing backup data using the Microsoft SQL Server Management Studio
- Restoring Enterprise Vault data
- About the Enterprise Vault restore options on the General tab
- About the Enterprise Vault Database Settings tab
- Specifying the server, clients, and policy type for restores
- About restoring Enterprise Vault file system data
- Restoring an Enterprise Vault file system component
- About restoring Enterprise Vault SQL databases
- Restoring Enterprise Vault SQL database components
- Disaster recovery
- Disaster recovery requirements for Enterprise Vault server
- About disaster recovery of an Enterprise Vault site
- Recovering a directory database
- Recovering an auditing database
- Recovering an FSA Reporting database
- Recovering a Monitoring database
- Recovering index locations
- Recovering an Enterprise Vault vault store group
- Recovering a fingerprint database
- Recovering a vault store database
- Recovering vault store partition
- Recovering Enterprise Vault partitions
- Recovering an Enterprise Vault server
- Recovering an Enterprise Vault server on a different system
- Enterprise Vault Agent support for Enterprise Vault
- Policy configuration for Enterprise Vault
- Notes about Enterprise Vault 10.0 backups
- Excluding files from the exclude list
- About planning backup schedules
- About hosts for Enterprise Vault policies
- About Enterprise Vault tools
- About Enterprise Vault agent backups
- About Enterprise Vault agent restores
- Useful tips about Enterprise Vault agent
- Enterprise Vault agent functionality and support for Enterprise Vault
- Troubleshooting
- Appendix A. NetBackup Enterprise Vault Migrator
- About the Enterprise Vault Migrator
- About configuring a backup policy for migration
- About configuring Enterprise Vault for collection and migration
- Testing the Enterprise Vault migrator configuration
- Setting the recommended DCOM settings
- Restoring Enterprise Vault migrated data from NetBackup
- Troubleshooting the Enterprise Vault migrator
About backup image restore sets
Backup images are displayed in the Backup, Archive, and Restore interface. These images correspond to Enterprise Vault file system data or Enterprise Vault SQL databases. The images that you select comprise a backup image restore set.
To perform an Enterprise Vault SQL database restore or a recovery with Point in time (PIT), first determine the time to which you want to restore or recover the database. Next, decide upon the group of backup images that need to be restored in a sequence to restore or recover the database. This group of backup images is called a backup image restore set. A backup image restore set consists of the following images:
Note:
Recovery is only possible with SQL differential (transaction log) backup images.
Full backup image: A restore set starts with a full backup image.
Cumulative backup image: Add the last, cumulative backup image to the set. Add this image if it occurred between when the full backup image was taken and the time you decided to perform the restore or recovery.
Differential backup images: Add the differential backup images that occurred between the last cumulative backup (or full backup if no cumulative backup happened) and the time that you decided to perform the restore or recovery. If you want to perform a recovery with PIT, then include the immediate differential image after the PIT in the restore set.
The following example demonstrates how to determine a backup image restore set in different use cases.
Table: Understanding which backup images to select for a restore demonstrates which backup images you would select to comprise a backup image restore set at any given time instance. Depending on the time you want to restore or recover the database, determines which backup images you must include in the backup image restore set.
Table: Understanding which backup images to select for a restore
Time instance | The backup images that comprise the backup image restore set |
|---|---|
t1 | Full backup |
t2 | Full + Differential 1 (PIT) |
t3 | Full + Differential 1 |
t4 | Full + Differential 1 + Differential 2 (PIT) |
t5 | Full + Differential 1 + Differential 2 |
t6 | Full + Differential 1 + Differential 2 + Differential 3 (PIT) |
t7 | Full + Cumulative |
t8 | Full + Cumulative + Differential 3 (PIT) |
t9 | Full + Cumulative + Differential 3 |
t10 | Full + Cumulative + Differential 3 (SQL tail-log backup) |
The following examples explain which backup images you must select in the Backup, Archive, and Restore interface:
Example 1:
To restore an SQL database to time instance t3, your backup image restore set must consist of the following backup images:
The full backup image with the options and or enabled.
The first differential backup image with the option enabled.
Example 2:
To recover an SQL database with PIT at time instance t8, your backup image restore set must consist of the following backup images:
The full backup image with the options and or enabled.
The last cumulative-backup image with the option or enabled.
The third differential backup image with the option and enabled.
Example 3:
To recover an SQL database at time instance t10 which is after the last differential backup, you must use Microsoft's SQL tail-log mechanism. For more information about performing a tail-log backup, visit Microsoft's website and search for more information on this topic.
In this example the backup image restore set would include the following images:
The full backup image with the options and or enabled.
The last cumulative-backup image with the option or enabled.
The third differential backup image with the option and enabled.
Perform a tail-log backup. See Microsoft's website for instructions on how to perform this type of backup.