Groups | Blog | Home
all groups > sql server replication > august 2005 >

sql server replication : export session details


TCorp
8/25/2005 7:50:54 PM
My (pull subscription) replication agents allow me to view each agent's job
history and seasson details in the replication monitor (Enterprise Manager).
How I can export this list to examine more closely outside of EM?

TIA,



Hilary Cotter
8/27/2005 7:33:26 AM
Set HistoryVerboseLevel to 3. Now your history will not be overwritten, but
you will have a slight performance degradation. Now as you are using pull
the history will be retained on the Subscribers. DTS is locally. History by
default only hangs around 2 days, you might want to set the history
retention period to something larger. Do this by right clicking on
Replication Monitor and selecting Distributor Properties. Click on the
Properties button and set History Retention to something larger.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

AddThis Social Bookmark Button