Dear all, My client has requirement as below. They are having SQL server 2008 database which got too bulky effecting the performance. So they decided to copy the same database to other database (which would be used for reporting) and the from the original database they deleted all the data prior to 3 yrs. So the original database is trimmed and this becomes principal database and is used for transactions and used by the application to insert new data. Now the requirement is, copied (reporting database) database should be replicated from the principal database for newly inserted data. It should be done real time, and its not viable, at least it should be done with 5-10 mins. At anytime the reporting database should be having full database of all the years but the transaction database will have only latest three years data only. Now I am in question which method I should use to do data replication and what are the challenges. considering their budget is very limited and near-time data reporting and full transaction safety.. also last note, I heard that replication is good for load balancing, you can distribute your database to multiple servers. can you let me know if this can be used in my case? Thanks you all.