all groups > sql server replication > may 2007 >
You're in the

sql server replication

group:

SQL 2000 Replication Log



SQL 2000 Replication Log ganbade NO[at]SPAM gmail.com
5/22/2007 7:27:42 AM
sql server replication: Hi,

I'm new in SQL 2000 Replication, hope the guru's can help on my
following query.
a) Is the replication produce log file?
b) If the answer is yes, where can i get the log files & what's the
name of the log file
c) Will the log file grow rapidly?
d) What's the recommended book / site to read about replication (in
depth such as frequent error, fine tune & troubleshoot whenever there
is an error during replication)

Thanks.

Cheers,
Gan
RE: SQL 2000 Replication Log Paul Ibison
5/22/2007 8:21:02 AM
Depends what you mean by log file really :). Informational messages (agent
execution history) are automatically logged in the agent history tables and
are retained there only for a configurable set time. They are available via
the Replication Monitor. For troubleshooting we can log to text files and get
detailed info about the synchronization process. We also have the hostory of
the sql server agent job itself. In terms of transactional replication we can
monitor the commands going through to the subscriber and this is treated as a
temp log in some cases.
Is there any particular bit of info you want to monitor?
There are 2 books out there specializing on replication. Both are linked to
on www.replicationanswers.com. This is my site and I would be a fool not to
recommend it as well :). It has a series of articles which help overcome
certain issues and common problems/questions.
Cheers,
AddThis Social Bookmark Button