# Back Up Database

> Back up the PerformanceGuard database, and which SQL Server versions each PerformanceGuard version supports.

Source: https://docs.capaone.com/performanceguard/administration/more-setup/back-up-database/  
Product: PerformanceGuard — a separate CapaSystems product; do not apply this page to any other.

PerformanceGuard supports the following relational database management systems:

- **SQL Server 2012** (CPU license) from PerformanceGuard version 6.1.16
- **SQL Server 2014** from PerformanceGuard version 6.5.100
- **SQL Server 2016** from PerformanceGuard version 7.0
- **SQL Server 2017** from PerformanceGuard version 7.4
- **SQL Server 2019 RC1** have been tested with PerformanceGuard version 7.5 but no official release was available from Microsoft at the time of the release of PerformanceGuard 7.5

:::caution
The following information was written when PerformanceGuard supported SQL Server 2008 and 2008 R2. It describes how to back up a SQL Server 2008 R2 PerformanceGuard database. The procedure may vary slightly for other SQL Server versions, but you can still use the following as guidelines—also if you use newer SQL Server versions.
:::

:::caution
The following describes backup of the PerformanceGuard backend server database, by default named *pguard*. If you want to back up a different database, substitute *pguard* with the name of the required database.
:::

1. Open Microsoft SQL Server Management Studio and connect to the required database server.
2. In Microsoft SQL Server Management Studio's Object Explorer, locate the **pguard** database.
3. Right-click **pguard** and select **Tasks > Back Up...**  
   ![](/attachments/performanceguard/7624e54d-2af4-4a96-8cf8-f12f873ece82.png)
4. In the **Source** section of the **Back Up Database** dialog's **General** page, make sure that:

   - the database **pguard** is selected
   - the backup type **Full** is selected
   - Then make a note of the backup destination in the bottom part of the dialog.  
     ![](/attachments/performanceguard/4f4d5f16-f63a-41d1-9ed6-2d615ae244c9.png)
5. Switch to the **Back Up Database** dialog's **Options** page and select **Overwrite all existing backup sets**.
6. Click **OK**.  
     
   The backup process will begin, and you'll be able to view its progress. It can take a while to back up the database. When the backup is finished, you'll see a confirmation message. The backed-up database has now been saved as a .bak file at the destination you made a note of in step 4.  
   For information about how to restore your backed-up database, see [Restore Database](/performanceguard/administration/more-setup/restore-database/).