X hits on this document

422 views

0 shares

0 downloads

0 comments

65 / 200

Full

Create a full database backup.

Full differential

Create a differential backup.

Transaction log

Create a transaction log backup. This type of backup is only available for databases. When you select this type of backup, you then need to select a backup option from the Transaction log backup options list.

Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface

Backup options

The following options are available when you perform backups. You see these options in the Backup Microsoft SQL Server Objects dialog box after you choose File > Backup SQL Server objects.

Type of Backup

65

Expand database

This pane allows you to traverse live databases. You can expand the SQL Server instance to view its databases. Expand each database to view its filegroups or expand a filegroup to view its files. You can select any object in this pane in order to view its constituent objects in the right-hand pane.

Select database(s) for backup from instance host\instance

Select the objects that you want to back up from this pane. This pane displays the list of constituent database objects of the highlighted host\instance in the left-hand pane. You can select one or more objects (databases) in this pane. (Use Ctrl + click and Shift + click to select multiple objects.)

Table 5-9

Option

Options for backup operations

Description

Read/write filegroups

Create a backup of read/write filegroups in a database.

Differential on read/write filegroups

Create a differential backup of read/write filegroups in a database.

Create a template for partial backup

Create a backup of only the selected filegroups in a database.

Create a template for partial differential backup

Create a differential backup of only the selected filegroups in a database.

Note: The following four backup

types are only available for SQL Server 2005

Back up transaction log, but do not truncate it

Back up a transaction log without truncating it.

Transaction log backup options

These options are available when you have chosen a transaction log backup type.

Back up and truncate transaction log

Back up the transaction log and remove the inactive part of the transaction log.

Document info
Document views422
Page views422
Page last viewedSun Dec 04 08:57:44 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments