SureSync KB
      Back to home
      1. Software Pursuits Support Center
      2. SureSync KB

      Moving a SureSync SQL database to a new SQL server machine

      If you need to move the SureSync SQL database to another SQL server, follow these steps.

      1. Stop all running Jobs, Schedules and Real-Time Monitors in the SureSync Desktop.
      2. Take a backup of the SureSync SQL database using SQL Management Studio. A Microsoft reference for this process can be found at https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver16.
      3. Restore the backup of the SureSync database to the new SQL server.
      4. Open SureSync and go to Home | Database | Open Existing Database and open the database on the new SQL server.
      5. Restart the Scheduler service.
      6. Start any necessary Jobs, Schedules and/or Real-Time Monitors.