Restore the Synergy database backup using SQL 2008 R2 Management Studio

Setup required before use	Who Can Use It?	Where Is It?
SQL 2008 R2 install on the server Synergy database backup Moving the Synergy Server Install SQL Management Studio	System Administrator	Microsoft SQL Server 2008R2 Management Studio

Find this at Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.

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.

In the Object Explorer panel, highlight the 'Databases' folder.

Right mouse click the Databases folder and select the 'Restore Database' option.

In the pop-up shown, select 'From Device' in the 'Source for restore' section.

Then select Browse , to find the backup file already created.

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.

Check the 'Restore' box, in the 'Select the backup sets to restore' table.

In the 'Destination for restore' section, use the 'To database' drop down to select 'Synergy' from the list.

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.

Go back to the General page. Confirm that the Synergy database is shown, and the restore check box is selected. Press OK.

The restore process can take a few minutes. Follow the progress in the bottom left corner of the screen.

When the restore is complete a pop-up is shown. Press OK.