Distribution database

Do we need to do any maintenance tasks on distribution database in
transactional replication after the replication is setup..?
Any advise...
Regards,
Ravi
No, there is a distribution clean up agent which will prune the distribution
database of replication metadata.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:2248D094-CD16-4F9F-82CC-C38E19BAFFD1@.microsoft.com...
> Do we need to do any maintenance tasks on distribution database in
> transactional replication after the replication is setup..?
> Any advise...
> Regards,
> Ravi
|||In terms of removing metadata please see Hilary's reply. In terms of disaster
recovery, it depends on what your strategy is. If you're using transactional
replication, then there should definitely be a backup plan in case of the
database and transaction logs. Because of the way merge works this is less
important in terms of keeping perfectly up to date, but is still required if
you don't want to reset up replication in any way.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)