title: Database replication. 2 servers, Master database and the 2nd is read-only
body: <p>Say you have 2 database servers, one database is the 'master' database where all write operations are performed, it is treated as the 'real/original' database.  The other server's database is to be a mirror copy of the master database (slave?), which will be used for read only operations for a certain part of the application.</p>
  
  <p>How do you go about setting up a slave database that mirrors the data on the master database?  From what I understand, the slave/readonly database is to use the master db's transaction log file to mirror the data correct?<br>
  What options do I have in terms of how often the slave db mirrors the data? (real time/every x minutes?).</p>