The following backup types are available:

• 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.

• 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.

The following 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.

• Back up transaction log, but do not truncate it

  Back up a transaction log without truncating it.

• Back up and restore tail log

  Back up and recover the tail log from disk.

• Launch Immediately

  Start the backup operation immediately.

  Launch immediately is disabled if you are logged into a SQL Server instance that is not on the local host. If you generate a script for a non-local host, then it must be executed on that host.

• Save

  Generate a script that can be started at a later time.

In the right-hand pane, choose one of the following backup options:

• Selected

  Back up only the objects selected.

• All but selected

  Back up all of the objects, except those selected.

• All

  Back up all of the objects.

• Do not resume unsuccessful backups

• Retry from the beginning

  Restart failed backups after waiting 60 seconds.

• Save work and restart at point of failure

  Divide the backup into multiple streams and back up separately. Any streams that fail are restarted after 60 seconds.

  This option is available when the following conditions are met:

  • Exactly one object has been selected,

  • The object that is selected for backup is a database or filegroup and the backup type is full,

  • The SQL Server object uses the "full" or "bulk-logged" recovery method.

• Do not perform verification

  Do not perform page verification before you run the backup.

• Perform verification

  Perform page verification when you run the backup and stop the backup if a verification error is encountered.