Solved

SQL Server 2005 will not keep history longer than 1 day

Posted on 2011-03-20
6
273 Views
Last Modified: 2012-05-11
Have SQL Server 2005 and job keeps history longer than 1 day.

All settings are corect, no maintenance tasks to cleanup any history etc.,

We dont have any job history limits etc.,

Any suggestions
?
0
Comment
Question by:itmti
  • 4
6 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 35175086
check the sql server agent settings, there is also a config to delete older job history entries.
also, the jobs can store how many entries they store, which is not linked to time, actually.
0
 

Author Comment

by:itmti
ID: 35175091
Checked and was nothing checked.
SQL-Server-Agent.png
0
 

Author Comment

by:itmti
ID: 35175108
There was a history cleanup job to cleanup 1 year history, disabled that and trying again.

0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 250 total points
ID: 35187701
itmti,
     Is it 1 day or 1 year? Anyway hope this will work.
0
 

Author Comment

by:itmti
ID: 35189443
it was 1 year

but disabled completely that part of maintenance and started to work
0
 

Author Closing Comment

by:itmti
ID: 35189449
thanks
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

828 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