Documentation Center

Backing up the Microsoft SQL Server database

Follow this procedure to backup your Microsoft SQL Server database.

Procedure

  1. Open SQL Server Management Studio.
  2. Open the Databases folder.
  3. Right-click your database.
  4. Select Tasks > Back Up.
  5. Backup type should be Full.
  6. Enter a Name for the backup.
    It is recommended that you use the format: yyyymmdd.projectname.bak to name the backup.
  7. Ensure that Backup set will expire: After 0 days
  8. In the Destination pane at the bottom of the window, click Add.
  9. Add a destination folder such as: yyyymmdd.projectname\SQLServer\Dump.
  10. Click Options in the left pane and verify that the information is accurate:
    • Backup to the existing media set.
    • Append to the existing backup set.
    • Verify backup when finished.
  11. Click OK.
    The backup of the database starts.