• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

MS SQL replication monitor only shows a few days worth of history

I am running MS SQL server 2008 R2 for both publisher and subscriber. When I launch replication monitor, I am only able to view about 3 days worth of history. Is there a way to show 15 days or more of replication history?
0
sqlagent007
Asked:
sqlagent007
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
Open SQL SSMS, connect to your SQL as SA and reight click your SQL Agent then select Properties - there you can set the "History" for Log/Job.
0
 
sqlagent007Author Commented:
Thanks. I adjusted to 15 days.
0
 
lcohanDatabase AnalystCommented:
You may also need to increase the max number of entries per SQL Agent Log/Job if you have jobs on that server running with high frequency.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now