Asked by:
sysjobhistory table corrupted how to recover on sql 2008 r2

-
sysjobhistory table corrupted how to recover ron sql 2008 r2
- Moved by Vincent Chen (X)Microsoft employee Wednesday, January 21, 2015 12:07 AM
Question
All replies
-
Please paste the error, resolution is to store the recent MSDB full backup.
Regards, Pradyothana DP http://www.dbainhouse.blogspot.in/ Please Mark This As Answer if it solved your issue.
- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, January 19, 2015 7:35 AM
-
What makes you think sysjobhistory is corrupt? In SQL Server, table corruption is extremely rare.
Is it missing records you think should be there? That is caused by the SQL Agent retention policy.
Please see:
- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, January 19, 2015 7:35 AM
-
Can you show us the error that it is corrupt, how did you found out. Is there any message present in errorlog
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
My Technet Wiki Article
MVP- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, January 19, 2015 7:35 AM
-
-
Is it anything related to Master Data Services or just a generic question for SQL Server Agent?
I guess its generic question and must be moved to database engine forumPlease mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
My Technet Wiki Article
MVP