X hits on this document

431 views

0 shares

0 downloads

0 comments

59 / 200

Backup and recovery concepts Recovery factors

  • file

  • read-only filegroups

  • read-only filegroups differential

  • partial database

  • partial database differential

  • transaction log

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:

1

Full database backup set: A full database image, an optional database differential image, and one or more transaction logs.

2

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.

3

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.

4

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.

59

Document info
Document views431
Page views431
Page last viewedSun Dec 04 18:48:57 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments