Backing Up a Microsoft SQL Server 2008 or 2012 Database

You can create a full database backup of a Microsoft SQL Server 2008 or 2012 database.

Performing a backup

  1. Open Microsoft SQL Server 2008 or 2012 Management Studio.
  2. Connect to the used by Workflow.
  3. Under your server name in the , expand the Databases folder.
  4. Right-click the database used by Workflow.

    Note: The SQL server and database used by Workflow are defined using the Workflow Server Configuration Manager.

  5. Point to Tasks and select Back Up.
  6. Next to Backup Type, select .
  7. For Backup component, select .
  8. Optional: In the Description text box, enter a description of the backup.
  9. Specify when the backup will and can be overwritten.
  10. Choose the by clicking Disk or Tape. To select more paths, click Add.
  11. Optional: To view or select advanced options, click Options in the Pane.
  12. When you have finished configuring, click OK to start the backup process.