Where is the log file located when verbose history logging is turned on for SQL 2005 replication?

Question

Hello,

I keep getting the The merge process was unable to create a new generation at the 'Subscriber'. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200994) Get help: http://help/MSSQL%5FREPL-2147200994 message. I went ahead and followed the advice and from the Replication monitor->Agent Profile I changed the profile to Verbose history. Now, where is this file located? There are not properties in Management studion to sepeify the location. Thank you.

Answer 1

I found the answer. Just go to the subscribers replication JOB open it up go to steps->Edit Run Agent job(usually the default job created)->under General in the Command window add -Output c:\YourReplicationLog.txt and the file will be on your c drive.