title: SQL Server Database real-time replication
body: <p>I have a database on an SQL Server instance hosted on Azure Windows VM. There are two things I need to achieve. </p>
  
  <ol>
  <li><p>Create a real-time duplicate of the database on another server. i.e. I need my database to make a copy of itself and then copy all of it's data to the duplicate at regular intervals. Let's say, 2 hours.</p></li>
  <li><p>If my original database fails due to some reason, I need it to redirect all read/write requests to the duplicate database.</p></li>
  </ol>
  
  <p>Any elaborate answer or links to any articles you deem helpful are welcome. Thank you! </p>