Solved

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

Posted on 2013-01-15
3
485 Views
Last Modified: 2013-01-15
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
Comment
Question by:sqlagent007
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 38779205
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
 
LVL 1

Author Closing Comment

by:sqlagent007
ID: 38779295
Thanks. I adjusted to 15 days.
0
 
LVL 39

Expert Comment

by:lcohan
ID: 38779633
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql join/ assign small # first 10 83
AWE-based memory on 32-bit servers 1 23
Solution for warm standby SQL server 20 39
How to use odbc in vb to connect to ms sql 14 38
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now