Replication History

[Kleptican]

Hey all,

Does SQL Enterprise Manager store all of the information that would have been replicated to the publisher and vice versa? Basically, the subscribers that sent updates to the publisher and the publisher that sent updates to the subscribers, does SQL store when updates were sent and/or what was sent?

Thanks.

 

[mrdenny]

Nope. Once the information is transmitted to all members of the replication schema the information is removed from the distribution database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com