Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KabirPatel
Yak Posting Veteran
54 Posts |
 Posted - 2007-09-10 : 04:51:24
|
| Hi,I have a general question regarding Transactional replication in SQL Server 2000. Could somebody please point out to me what the major risks are regarding transactional replication for both the subscriber and publisher?Thanks,Kabir |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-10 : 16:18:02
|
| this is something you need to test on your ownone's major risk may not be your conceived major riskFor example, a huge massive update or deletes from the publisher propagated to the subscriber, then cancelled and a rollback is doneI've encountered this in one of my previous job and the rollback took 6 hours! In which case the subscriber which was being used as reporting server became unavailable since the articles are the major tables used in the reports--------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-10 : 22:41:27
|
| What's the subscriber for? As reporting DB? |
|
|
|
|
|
|
Transactional Replication