Hi,

There's no magic book around (I know only one book about transactional replication, written by Hilary Cotter). However, Books Online contains many bits about how things work, you just have...

hi,

Absolutely no warranty that it will work. That is, it will work in case the state of the publisher and distributor and subscriber databases are taken from the very same...

Hi,

You may want to turn on logging for the problematic agents and find the exact rows failing. Edit the job step by adding the option "-Output E:\ReplDistrAgent.log " to the...

Hi,

It depends on - is the latency of your subscribers higher when this message shows up? For me, I couldn't find the root cause but a simple agent restart solves...

Express edition can participate in replication as a subscriber for push replications only. Or you have to hack a bit around with arming distrib.exe from a "full" SQL edition.

I had a SQL2005 server and I installed a SQL2008 next to it. No problem, except the user experience: SSMSs look the very same in the recent program list 🙂

MERGE provides approximately the same performance as the previous "upsert" solutions. If you need performance and upsert/merge operations, and the majority of the operations are updates then try the TRY...[UPDATE]......

Hi,

There's no connection between backup schedule and data loss possibilities in replication. So schedule your backup in a way you remain able to restore as many data as you need....

Maurizio79 (4/1/2008)

I want to use more distribution server, that is what i consider "scale out".

But there is that possibility in sql2k5? That is, can I have something like: 100 publications,...

Hi Matt,

You can set up transactional replication from the production database to the reporting one. It's not so complex, read the BOL and you'll succeed. Reporting Services is a good...

Hi Nicole,

There are some hidden details, but based on the info you provided, if I were you, I would use mirroring between A1 and A2, and script out the replication...

Andy,

Even if everything goes fine, no warranty that you'll have the same number of records in the subscription databases as the subscriber finishing last will have the most record. It's...

Maurizio,

I'm quite sleepy now, so no idea what I'm writing, but you may find something useful in it. First of all, there's no easy way to happiness 🙂 You can...

Some thoughts...

1. Replication can be very troublesome, that's true, however, in general, I found the system reasonable in one way or another, so I do believe in determinism 🙂

2. I...

IMHO you would be very surprised 🙂

I assume you have transactional replication based on what you wrote. If you stop the log reader agent, transactions will wait in the log...