Manual Backup and Restore

Have you tried using the Backup & Restore utility tool? If not, start there first.
If for some reason the tool does not work in your environment, then use the manual steps below.

Use standard Windows SQL backup and restore procedures. You can find instructions can be found on the Microsoft SQL Docs site "Create a Full Database Backup".

Download and install Microsoft SQL Server Management Studio. Keep all the defaults during installation.

  1. Back up the SQL database.

  2. Export the Syn-Apps Registry settings:

    HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Syn-Apps

    Use standard Windows Registry export commands.

  3. Install Revolution on the new server using the same license file and SQL passwords that you used for the original install.
  4. Reboot the server.
  5. Restore the SQL database to the new server.
  6. Restore the Syn-Apps Registry settings.
  7. Navigate to C:\Program Files (x86)\Syn-Apps\SAAnnounceRevolution and double-click on restoreUsers.sql to run the script. The SQL Server Management Studio automatically opens.

    8. Do one of the following:

    • First time opening SQL Server Management Studio – For Server name, enter .\SYNAPPS and select Connect. The script runs.

      • Note: You might see something like WIN-AB012CD4E5F\SYNAPPS already populated in the Server name field, or the field may be blank. Replace whatever is there with .\SYNAPPS.

    • Select Connect. The script runs.
  8. Restart the Revolution services or reboot the server.
  1. Backup the SQL database, if you can.

  2. Export the Syn-Apps Registry settings:

    HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Syn-Apps

    Use standard Windows Registry export commands.

  3. Uninstall Revolution.
  4. Install a fresh installation of Revolution using the same license file and SQL passwords that you used for the original install.
  5. Reboot the server.
  6. Delete the old SQL database and restore from backup.
  7. Restore the Syn-Apps Registry settings.
  8. Navigate to C:\Program Files (x86)\Syn-Apps\SAAnnounceRevolution and double-click on restoreUsers.sql to run the script. The SQL Server Management Studio automatically opens.

    9. Do one of the following:

    • First time opening SQL Server Management Studio – For Server name, enter .\SYNAPPS and select Connect. The script runs.

      • Note: You might see something like WIN-AB012CD4E5F\SYNAPPS already populated in the Server name field, or the field may be blank. Replace whatever is there with .\SYNAPPS.

    • Select Connect. The script runs.
  9. Restart the Revolution services or reboot the server.