title: Replication in SQL Server 2008 R2 if Source and Destination Tables indexes are different
body: <p>To fine tune the performance of overall system, I was checking the existing table's Indexes and found that we are using a ErrorLog table which is hit(for writing warnings and errors) for millions of transactions everyday. As we have indexes(on datetime) on this kind of table I thought this logging will definitely takes longer than the logging in to table without any indexes.</p>
  
  <p>The whole indexing on CreateDateTime is used only by Developers for querying the table for troubleshooting in Production environment. Is it possible to take out index on the primary production server and have index only for the table in secondary(backup) db server. As we are doing replication on secondary server data is always in Sysc.</p>
  
  <p>To Sync both the tables via replication, do we need to have same indexes on both tables?</p>