Restoring Symmetry Databases

This guide is now available via a video demonstration:

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

Introduction

Symmetry databases can only be restored using SQL Server Management Studio. In this article we will explain how to restore Symmetry databases using SQL Server Management Studio.   

Restoring Symmetry Databases Using SQL Server   

Step 1: We need to stop all Symmetry Services. 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. We need to start with Multimax database:   

Step 3: First we need right click Multimax Database, and select Tasks, Restore, then Database option as shown below:    

Step 4: SQL Server will open the Restore Database window below, then we choose the source and we set it to Device, and click the Browse button:     

Step 5: Then we need to Browse to our backup location, select Add in Backup Devices Window, and select the backup location (Multimax.bak),  click OK, and OK again:

Step 6: The Restore Database window will show the Multimax backup file:    

Step 7: In the Restore Database window please select Options and choose Overwrite the existing database option, and click OK to restore the backup:  

Step 8: We should get the Window below and the Database “Multimax” should restore successfully:  

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

• Right click MultimaxTxn database and select Tasks, Restore, then Database option. 
• Use the Restore Database window and choose Device, and click the Browse button
• Then click Add in Backup Devices Window, and select the MultimaxTxn backup location   
• Select the MultimaxTxn backup file (MultimaxTxn.Bak)   
• Click OK, and OK, and the Restore Database window will show the MultimaxTxn backup file
• In Restore Database window please select Options and choose Overwrite the existing database option, and click OK to restore the backup.

Step 9: Once the Databases restored (Multimax and MultimaxTxn), we need to Re-run the Symmetry setup and select Repair:

Step 10: Then select Repair again, and this will then run through the repair process, once this completes we should have a working Symmetry system restored to the point our backup was taken.      

Please check the Video below for further details: