Databases Backup Through SQL Server Management Studio

This guide is now available via a video demonstration:

https://www.youtube.com/watch?v=tEeNTDA3imc

Introduction

There are two main ways to backup Symmetry Databases, the first using Symmetry Application, and the second using SQL Server Management Studio. In this article we will explain how to backup the databases using SQL Server Management Studio.

Backup Symmetry Databases Using SQL Server  

Step 1: We need to stop all Symmetry Services, this ensures the data isn’t being written to the Databases when we try to back them up. Please open Symmetry Service Monitor in Windows System Tray and stop all Symmetry Services.          

Step 2: We need to open SQL Server Management Studio, using Object Explorer on the left please expand Databases and we will see all Symmetry Databases as show below:   

Step 3: First we need to backup Multimax Database, right click Multimax and select Tasks, then Back Up option:    

Step 4: SQL Server will open the Back Up window below with the Default location under Destination, please click Remove button below to remove the default location,     

Step 5: Then click Add button above to add our new location (e.g. C:\Backups), this will show the Select Backup Destination Window, please select (…) button to Browse, then select the new backup location, and type the name of the database with BAK file extension (Multimax_Date.Bak) in the File Name box below:

Step 6: Then we click OK, and OK again, and the Back Up window will show the new backup location under Destination, click OK to create the back up:    

Step 7: We should get the Window below and the backup should complete successfully:

Step 8: We need to use the same steps above (Steps 3-7) to Backup MultimaxTxn database:

• Right click MultimaxTxn database and select Tasks, then Back Up option
• Use the Back Up window and click Remove button below to remove the default location.
• Then click Add button to add our new location, and select (…) button to Browse 
• Select the new backup location, and type the name of the database with BAK file extension (MultimaxTxn_Date.Bak) in the File Name box
• Click OK, and OK, and the Back Up window will show the new backup location under Destination, click OK to create the back up.  

Step 9: Use Windows file explorer and open the new backup location (e.g. C:\Backups), we should get two new files (backups), Multimax database (configuration data), and MultimaxTxn database (transactional data).

Step 10: Finally, after completing the steps above to backup Multimax and MultimaxTxn databases, please open Symmetry Service Monitor in Windows System Tray and Start all Symmetry Services.          

Please check the Video below for further details: