Question Locked

MSDB size grown up to 5gb why it was happened?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
MSDB size grown up to 5gb why it was happened? where can i find the reasons? is there any SQL command to see what's in MSDB?

4 replies

by tony hopkinson

might be a start.

MSDB is sql server's task database, so it's scheduled jobs, barckup, scripts, subscriptions, maintenance plans and such.

A training course might be in order.

by theunique1011

Hi Tony Hopkinson....
I'm very thankfull for you response
but i couldn't understand ur answer.
can tell me exact reason why MSDB Size is increasing? and how to control it?

by tony hopkinson

Something is putting data in it.

Nothing is clearing it out.

Could be anything from a rogue job, to not MSDB being in full recovery mode and not backing up your logs.

You need to go on some courses mate...

Not talking quick answers here, more like a solid DB Background, and a week or so of lessons, just so you can ask better questions.

This discussion is closed to new replies.