title: What is transactional replication used for?
body: <p>What is transaction replication used? I seemed to create transaction replication following this tutorial: </p>
  
  <p><a href="http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/" rel="noreferrer">http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/</a></p>
  
  <p>And I know when I change some objects i.e any DML or DDL statement, those changes will be reflected to the other server where I did replication. But it's not clear to me why should we use transaction replication. Does SQL server automatically start using the 2nd server where replication was done when the main instance fails? or do we have to manually restore the database from the server where replication was done in case of failure of 1st instance?</p>
  
  <p>Thanks in advance :)</p>