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 SQL server used by Workflow.



3. Under your server name in the Object Explorer Pane, 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 Full.



7. For Backup component, select Database.



8. Optional: In the Description text box, enter a description of the backup.
9. Specify when the backup will expire and can be overwritten.



• To configure the backup to expire after a specific number of days, click After and enter the number of days. Entering zero (0) configures the backup to never expire.
• To configure the backup to expire on a specific date, click On and enter a date.
10. Choose the type of backup destination by clicking Disk or Tape. To select more paths, click Add.



11. Optional: To view or select advanced options, click Options in the Select a page Pane.



12. When you have finished configuring, click OK to start the backup process.