About selecting database objects for restore
This topic describes the hierarchical tree that appears. You can select the objects you want to restore.
This tree displays in the Restore Microsoft SQL Server Objects dialog box after you select File > and select the backup images you want to browse.
In the Restore Microsoft SQL Server Objects dialog box, you can expand the database hierarchy to see the database backup history for a NetBackup client. The backup client is typically the local host on which you are running NetBackup for SQL Server. However, you can select a client other than the local client in the Backup History Options dialog box.
Table: Selecting databases objects for restore describes how to select database objects for restore.
Table: Selecting databases objects for restore
Tree item | Description |
|---|---|
You can expand and collapse portions of the tree by clicking the and . The tree can be expanded as follows: | |
Level 0: Database instance | Items at this level cannot be selected. |
Level 1: Database icons | Items at this level cannot be selected. |
Level 2: Database backup images | These are full database backup images. |
Level 3: Database differential images These are differential backup images. | |
Level 2: Read-write Filegroups icon | Expand to display backups of the read-write filegroups in the database. |
Level 3: Read-write Filegroups backup images These images contain all of the read-write filegroups in the database. Level 4: Read-write Filegroups differential images These are differential read-write filegroup backup images. | |
Level 2: Partial database backup icon | Expand to display a list of partial database backup images. |
Level 3: Partial database backup images These images contain backups of some of the filegroups that are contained in the database. To view the contents of a partial database backup image, right-click an image and select . Level 4: Partial database differential backup images These images contain differential backups of filegroups that are contained in the database. To view the contents of a partial database backup image, right-click an image and select . | |
Level 2: Transaction log backup images | Each transaction log backup image appears with the date and time of the backup. |
Level 2: Filegroup icons | Expand to display a list of filegroups backup images. |
Level 3: Filegroup backup images Click the + next to a filegroup icon to view filegroup backups. The date and time of a backup is also displayed. Level 4: Filegroup differential images Click the + next to a filegroup backup image to view any filegroup differential backups. The date and time of a differential backup is also displayed. | |
Level 3: File icons The individual file icons appear at level 3. These icons cannot be selected for restore. Level 4: File images Clicking the + next to a file icon to view individual file backups. Each of these images appears with the date and time of the backup. |