MSDB.mdb file is 50GB

Question

MSDB.mdb file is 50GB

obulay

SSC Enthusiast

Points: 111
More actions
October 4, 2013 at 11:17 pm

#283455

When I run the query
http://stackoverflow.com/questions/3927231/how-can-you-tell-what-tables-are-taking-up-the-most-space-in-a-sql-server-2005-d
it only shows the total space of 100 MB.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

obulay (10/4/2013)
When I run the query
http://stackoverflow.com/questions/3927231/how-can-you-tell-what-tables-are-taking-up-the-most-space-in-a-sql-server-2005-d
it only shows the total space of 100 MB.

Did you ever know MSDB on your system to be smaller? What has probably happened is that someone forgot to clear the job logs over a long period of time and then someone remembered. Clearing the logs doesn't return space or shrink the database. In the SSMS Object Explorer (press the {f8} key to see it if not visible), right-click on the MSDB database (it's under "System Databases in case you don't know), select "Reports" ,"Standard Reports", "Disk Usage", and see how much free space there is.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

You have any service broker configured anywhere?

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

obulay SSC Enthusiast Points: 111 More actions · Answer 3

Yes, It was 50 GB Service Broker Queue. I had no way to delete it in batches, so My MSDB log grow to 200 GB to log the delete operation. Thank you.