Back Up Database

For the SQL Server versions that PerformanceGuard supports, see Software Requirements.

Caution

The following procedure was written for SQL Server 2008 R2. The procedure may vary slightly for other SQL Server versions, but you can use it as a guideline for newer SQL Server versions too.

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…
   

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.
     

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.