title: Database backup with another server using SQL Server 2005
body: <p>I have active Server A and standby Server B and B is replicating data from Server A. </p>
  
  <p>I'm using SQL Server 2005 enterprise edition. </p>
  
  <p>When Server A is failed, the application server is programmed to route traffic to Server B. </p>
  
  <p>Then Server B becomes active server and Server A becomes standby server. </p>
  
  <p>To turn Server A to be active server, the data modification when Server A failed in Server B needs to replicate back to Server A. </p>
  
  <p>I don't want to over load in active server. </p>
  
  <p>I'm thinking to use pull transactional replication method for replication. </p>
  
  <p>But I want to know what is the best method for doing above operations because this is the first time doing this operation for me. </p>