Backup and recovery concepts Recovery factors
read-only filegroups differential
partial database differential
When you select a transaction log for restore, NetBackup for SQL Server automatically searches for a set of images from which to stage a full database recovery. The recovery set consists of the selected transaction log image plus additional images which could reconstitute the database to a recovered state. A full recovery set can include any one of the following:
Full database backup set: A full database image, an optional database differential image, and one or more transaction logs.
File and filegroup set: A set of filegroup and/or file images which constitute the database, an optional filegroup differential image for any of the filegroup images, and one or more transaction logs.
Database and filegroup differential set: A full database image, a filegroup differential image for each filegroup in the database, and one or more transaction logs.
Read-write filegroup set: A read-write filegroup image, an optional read-write filegroup differential image, and one or more transaction logs.
If a full recovery set is found, then all of the composite images will be checked. In addition, Stage full recovery is enabled. To view the full recovery set, right-click on the transaction log, choose Properties, and click on the Recovery Set tab.