September 24, 2012 at 8:16 am
This morning I came in, and it seems that my boss had power cycled one of our SQL Servers this morning because certain applications with SQL backends "weren't working." Since then, MSDB has been in recovery, and according to the SQL error.log, it's going to be around another 12hrs before it finishes (MSDB is about 170GB, mostly because of a never cleaned out sysmail_Mailitems table.)
My question is, while MSDB is in recovery, will any scheduled Agent Jobs run, or is the Agent down until MSDB finishes recovery?
As for why sysmail_mailitems was never cleaned out (it's got entries dating back to 2007 or so,) it's because we didn't realize DB Mail kept entries like that (accidental DBA) and just found out last week (when I was trying to figure out WHY MSDB was so large.) I had started a Job to purge sysmail (using the built-in SP,) which may have been consuming enough resources to slow the whole thing down, and caused this (I'm going to resetup the Job when I can, and have it do one year, then re-run the next night doing the next year, and so on.)
Thanks,
Jason A.
September 24, 2012 at 8:47 am
Agent will be down until MSDB is back online. All the job definitions, schedules, history, etc are in MSDB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 24, 2012 at 8:49 am
Thank you Gail! That's what I was thinking would be the case, but couldn't find anything to confirm it with a quick Google...
Jason
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply