I have SQL server 2008 R1 with standard edition.
I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the database is replicated to . I need to set up another database for OLTP reporting. I have huge Transaction logs
Is Transactional replication with initial snapshot replication the best solution or mirroring the best solution.
Are there any best practices that are available while setting up transactional replication for the database.