Skip to main content

Posts

Showing posts with the label Agent

How to recover msdb database from suspect mode

 It was Monday 9 th Jun 47 degr. temperature of Delhi-NCR. Temperature was like boiling me and database. When I reached my office( @ 8.45 am) got an alert from one of Server. “MSDB is in suspected mode” At the same time comes in my mind, this issue will boil me today.. I just tried to cool my self through cold drink then connected server from my local system using windows authentication mode..

Clean up History and Maintenance Clean-up History

Cleanup History and Maintenance Clean-up History related to Maintenance Plan. It is a bit confusing but they are totally different . If we are designing maintenance plan then we should also create cleanup history and maintenance clean-up history.