January 12, 2009 at 9:50 am
I swear I had a lot of history in that table, 9 months or so, but now it only goes back to 10-14-2008 ?!?! I can't find any jobs or settings that delete from that table. 1 other server also has 3 months, and 3 other servers go back a couple of years.
January 12, 2009 at 9:54 am
Is it possible that the database had to be rebuilt, or anything like that?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2009 at 9:56 am
No, it looks like all databases only go back 3 months on 2 of 5 servers. I can't remember any event on both servers from that time that would have affected it ...
January 12, 2009 at 12:32 pm
Do you keep a journal or log of server events or anything of that sort? Do you have any sort of audit trail on that data? If no to both, you may never know what happened.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2009 at 8:53 am
Is there Maintenance History Cleanup task in any of the Maint. Plan?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply