Question

Locked

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

By theunique1011 ·
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?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Well select * from SomeTable

by Tony Hopkinson In reply to MSDB size grown up to 5gb ...

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.

Collapse -

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

by theunique1011 In reply to Well select * from SomeTa ...

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?

Collapse -

Why is increasing

by Tony Hopkinson In reply to MSDB size grown up to 5gb ...

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.

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums