Looking for detailed synchronization logging in SQL Server 2008
370 pts.
0
Q:
Looking for detailed synchronization logging in SQL Server 2008
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the detailed, timestamped synchronization log that was available in SS 2000, and I have been unable to find anything like that in SS 2008. I have brought up the View Synchronization Status dialogue, the Replication Monitor, and the subscription overview that results from right clicking the subscription in Replication Monitor and selecting View Detail. The subscription overview is a nice feature, but it does not replace the detailed log; for example, the error listing at the bottom of this window has no timestamps.

Am I missing something, or am I looking for something that no longer exists? Thanks in advance... Steve B
ASKED: Mar 19 2009  2:57 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You can adjust the amount of logging by changing the OutputVerboseLevel setting in the SQL Agent job which runs the merge agent.

This article gives some information about it.
Last Answered: Mar 21 2009  9:29 PM GMT by Mrdenny   46795 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0