Transaction Replication

Transaction Replication

 

  

Hi All,
I want to setup of transaction replication of database size 94 GB with at
least 400 users always connected. Database grows with rate of 700 mb/day.
This is my production server.
I have tested with copy of this database on test server, its working fine.
I have confusion about the performance issue after implement with
transaction replication.
Any one can comment what the best way to implement transaction replication
on production database.

And the same way I want to implement log shipping for the reporting server
on same database for the BO purpose.

Thanks in Advance for nice suggestion.

Regards,
Harsh Kumar
Database Administrator - IT Dept.
9213469176


MS Sql Server LazyDBA home page