A Synergy database may need to be restored when you are moving Synergy to a new server. The instructions in this topic explain how to restore the database using SQL Management Studio. These instructions are required when you are upgrading SQL to a new version, before restoring the Synergy database.
Getting Started
|
Setup required before use |
Who Can Use It? | Where Is It? |
|---|---|---|
|
System Administrator |
Microsoft SQL Server 2008R2 Management Studio |
Tip:
If you require any assistance with this progress, please contact Synergy Support.
Phone:+61 2 8197 9000 between 8:30AM and 5PM AEST.
Email:support@totalsynergy.com.au
Follow the steps below to restore your Synergy database backup file, using SQL Management Studio.
Step 1: Open SQL Management Studio
Find this at Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
Step 2: Login
to SQL Server
The
username is 'sa' and the recommended password is 'Synergy2008'.
If using another SQL version, our default password matches the version number: e.g. 'Synergy2005' or 'Synergy2008' or 'Synergy2012' or 'Synergy2014'.
NOTE: If you created a customised password when installing SQL on the server, then please enter this here.
Step 3: Select the databases folder
In the Object Explorer panel, highlight the 'Databases' folder.
Step 4: Select restore database
Right mouse click the Databases folder and select the 'Restore Database' option.
Step 5: Select from device
In the pop-up shown, select 'From Device' in the 'Source for restore' section.
Then select Browse 
, to find the backup file already created.
Step 6: Locate the backup file
Click Add to locate the backup file on the computer or network.
Locate the backup file on the computer that you want to restore, and press OK.
Press OK to restore this backup file.
Step 7: Check the restore box
Check the 'Restore' box, in the 'Select the backup sets to restore' table.
Step 8: Select the Synergy database
In the 'Destination for restore' section, use the 'To database' drop down to select 'Synergy' from the list.
Step 9: Configure the restore options
Go to the Options page (using the Select a page panel on the left), and check the 'Overwrite the existing database (WITH REPLACE)' box in the 'Restore Options" table.
Step 10: Confirm the general settings and
restore the database
Go back to the General page. Confirm that the Synergy database is shown, and the restore check box is selected. Press OK.
Step 11: Restoring the database
The restore process can take a few minutes. Follow the progress in the bottom left corner of the screen.
Step 12: Restore complete
When the restore is complete a pop-up is shown. Press OK.
You can now close Management Studio. Restoring the database backup is complete.
Looking for more help? Try reviewing the following topics: View Topics
© 2019 Total Synergy Pty Ltd