December 15, 2008 at 12:29 pm
Hi all,
We are currently testing replication with hopes of it going into Production fairly soon. I currently have a publication set up that is replicating two tables to another database. I am using transactional replication and this has been configured as a push subscription. The subscription was not initalized with a snapshot because I chose to copy over the tables manually. The replication has been working very well, however in the Replication Monitor, I can't seem to view past transactions and I am under the impression I should be able to do this. I right click the subscription in the replication monitor and go to 'View Details". No matter which drop down I pick on this screen (View All transactions, View the last 100 transactions, etc) the message is always 'No replicated transactions are avaiilable.' I am 100% positive replicaton is occuring, so why is the monitor not capturing the transactions? Any insight into this would be greatly appreciated.
Thanks,
Adam
December 15, 2008 at 3:33 pm
I'm betting you're using the default distribution agent profile. That profile uses a "HistoryVerboseLevel" setting of 1 which continually overwrites the most recent history message of the same status type. You can use the agent profile "Verbose history agent profile." to see more information or you can change the value for HistoryVerboseLevel to one of the following (taken from BOL):
0: Progress messages are written either to the console or to an output file. History records are not logged in the distribution database.
1: Default. Always update a previous history message of the same status (startup, progress, success, and so on). If no previous record with the same status exists, insert a new record.
2: Insert new history records unless the record is for such things as idle messages or long-running job messages, in which case update the previous records.
3: Always insert new records, unless it is for idle messages.
December 15, 2008 at 3:35 pm
Awesome, I had stumbled across that setting and had a feeling it had something to do with it, but wanted to wait until someone replied to verify my thoughts. I'll give it a try, thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply