Share via


Maintenance Plan Wizard (Define Backup Database Transaction Log Task Page)

Use the Define Backup Database Transaction Log Task page to add a backup task to the maintenance plan.

Options

  • Backup type
    Displays the type of backup to be performed.
  • Databases
    Specify the databases affected by this task.

    • All databases
      Generate a maintenance plan that runs this task against all Microsoft SQL Server databases, except tempdb.
    • All system databases
      Generate a maintenance plan that runs this task against each of the SQL Server system databases except tempdb. No maintenance tasks are run against user-created databases.
    • All user databases
      Generate a maintenance plan that runs this task against all user-created databases. No maintenance tasks are run against the SQL Server system databases.
    • These specific databases
      Generate a maintenance plan that runs this task against only those databases that are selected. At least one database in the list must be selected if this option is chosen.
  • Backup component
    Not available for transaction log backups.
  • Backup set will expire
    Specifies when the backup set can be overwritten by another backup set.
  • Back up to
    Back up the database to a file or to tape. Only tape devices attached to the computer containing the database are available.
  • Back up database across one or more files
    Click Add to open the Select Backup Destination dialog box, and provide one or more a disk location, or tape device.

    Click Remove to remove a file from the box.

    Click Contents to read the file header and display the current backup contents of the file.

  • If backup files exist
    Specify how to handle existing backups. Select Overwrite to remove the old content of a file or tape, and replace it with this new backup. Select Append to add the new backups after any existing backups in the file or on the tape.
  • Create a backup file for every database
    Create a backup file in the location specified in the folder box. One file is created for each database selected.
  • Create a sub-directory for each database
    Create a sub-directory under the specified disk directory that contains the database backup for each database being backed up as part of the maintenance plan.

    Important

    The sub-directory will inherit permissions from the parent directory. Restrict permissions to avoid unauthorized access.

  • Folder
    Specify the folder to contain the automatically created database files.
  • Backup file extension
    Specify the extension to use for the backup files. The default is .bak.
  • Verify backup integrity
    Verify that the backup set is complete and that all volumes are readable.

See Also

Other Resources

BACKUP (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006

New content:
  • Added descriptions of Backup set will expire, Backup file extension, and Verify backup integrity.