May 13, 2009 at 9:43 pm
I want to use Transation replication for report server (replicate every table).
but
I have from varity of report such as
- real time report
- huge loder report
...
so
Transation replication can synchronic to production in real time? (for real time report)
Thank you in advance for any suggestion or other solutuion.
May 14, 2009 at 8:04 am
If your Tables in Publisher DB has PK, then you can set up the Transactional replication. Usually the latency is around 2 to 3 seconds. Does that answer your question?
-Roy
May 14, 2009 at 7:49 pm
Thank Roy
I don't test yet, but I plan job scheduled time run every 1 min. (Cannot least than that right?)
I don't know that I can get 2-3 sec. latency or not.
I have backup log for every 3 hours so it's not interrupt with transational replicate right?
May 14, 2009 at 10:08 pm
You can schedule transactional replication to be continuous or on a schedule. If you use a schedule you cannot go to less than a minute. However, if you use continous, you should get the 2-3 second latency.
Transaction log backups will not remove entries from the transaction log until the logreader has processed the log entry and added the relevant information to the distribution database. Transactional log backups are fully aware of transactional replication and will not interrupt transaction replication (and vice versa). The only potential issue that could arise is that you will not be able to trancate the transaction log if it contains transactions that have not been replicated. This is not normally a problem because, once they have been replicated, the next transaction log backup that attempts to truncate the log will do this.
May 14, 2009 at 11:57 pm
Thank happycat59
That make me a lot clear how replicate work.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply