Backing up a Database

Last modified: October 23, 2019

This topic describes how to create a database backup in SQL Server by using dbForge Fusion for SQL Server.

To back up a database:

  1. After connecting to a required instance of the Microsoft SQL Server Database Engine, in Database Explorer, click the server name to expand the server tree.

  2. Either select a user database or expand the System Databases folder and select a system database.

  3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.

  4. In the Connection list box, verify the connection name. You can optionally select a different connection from the list.

  5. In the Backup type list box, select a backup type.

  6. In the Database list box, verify the database name. You can optionally select a different database from the list.

  7. Optionally, you can select Copy Only Backup to create a copy-only backup. A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups.

    Note

    If the backup type is set to Differential, you cannot create a copy-only backup.

  8. For Backup component, either click Database or Files and Filesgroups.

  9. To select the paths, click Add. The selected paths are displayed in the Backup to disc box.

  10. To view or select the media options, click Media Options.

  11. Select the Overwrite Media option, by clicking one of the following:

  • Back up to the existing mediaset

    For this option, click either Append to the existing backup set or Overwrite all existing backup sets.

  • Back up to a new media set, and erase all existing backup sets

    For this option, enter a name in the New media set name text box, and, optionally, describe the media set in the New media set description text box.

  1. In the Reliability section, optionally check:
  • Verify backup when finished
  • Perform checksum before writing to media
  • Continue on error

  1. The options in the Transaction log section are inactive unless you are backing up a transaction log (as specified in the Backup type section of the General page).

  2. To view or select the backup options, click Backup Options.

  3. Specify when the backup set will expire and can be overwritten without explicitly skipping verification of the expiration data:

    • To have the backup set expire after a specific number of days, click After (the default option), and enter the number of days after set creation that the set will expire. This value can be from 0 to 99999 days; a value of 0 days means that the backup set will never expire.

    • The default value is set in the Default backup media retention (in days) option of the Server Properties dialog box (Database Settings Page). To access this, right-click the server name in Object Explorer and select properties; then select the Database Settings page.

    • To have the backup set expire on a specific date, click On, and enter the date on which the set will expire.

  4. Click Back Up.

  5. When backup is already in progress you can interrupt it by clicking the Cancel button.

  6. The Finish tab displays whether the backup process has been finished successfully.

  7. Click Finish to close the Backup wizard.