Looking for detailed synchronization logging in SQL Server 2008

415 pts.
Tags:
Microsoft SQL Server 2000
SQL Server 2000 migration
SQL Server 2008
SQL Server replication
SQL Server synchronization
SQL Server upgrades
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following