sysjobhistory table corrupted how to recover on sql 2008 r2

Question

sysjobhistory table corrupted how to recover ron sql 2008 r2

Answer 1

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.

Answer 2

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:

http://msdn.microsoft.com/en-us/library/ms190956.aspx

Answer 3

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

Answer 4

Is it anything related to Master Data Services or just a generic question for SQL Server Agent?

Answer 5

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 forum

---

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