How to Synchronize Two Microsoft SQL Databases on different servers?

• smartcard

  SSC Enthusiast

  Points: 112

  More actions

  June 27, 2019 at 2:30 pm

  #3658134

  I have a Windows VPS where I am running a script with MSSQL database.

  In order to have a real time / online backup, I am ready to get another (similar) VPS from a different hosting provider to setup an online one-way sync of the data (script & MSSQL) to the 2nd server.

  So that for any reason if my active server is down, I can manually point the DNS to the 2nd server.

  What is the best recommended way to do this?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 28, 2019 at 3:10 pm

  #3658490

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.