Create a full database backup.
Create a differential backup.
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
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
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.)
Options for backup operations
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.