I have multiple (in excess of 15 servers) DB servers and msdb is not over 35
MB on any of them. I guess it depends on the number of schedule jobs, etc.
but 14 GB seems rather large. Can you shrink it (dbcc shrinkfile)?

-----Original Message-----
From: Ellingson Cory (RCIS)
[mailto:mssqldba-ezmlmshield-x9740553.[Email address protected]
Sent: Monday, June 27, 2005 8:14 PM
To: LazyDBA Discussion
Subject: What size should the msdb database hover around?

My msdb database is sitting around 14 gig...I have had space issues with
this box, and wonder if this database should be smaller...I am still
attempting to backup and such, however, I am out of space, and there have
been numerous issues.

Cory Ellingson
Production Services


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page