6GB Msdbdata.mdf

May 14, 2007

Hi all,



On my PC I noticed that my msdbdata.mdf file grew to over 6GB. I did sp_spaceused on each of the tables and they are all OK. I looked at the queues and they also seemed OK. I finally looked at the properties and seen that it cannot be shrink since it is 95 percent used.



Any ideas on how I can get it back to normal size?



Thanks

Avi

View 2 Replies


ADVERTISEMENT

Msdbdata.mdf File Is Over 5 GB, Cannot Shrink It

Jul 18, 2007

I have problem with my sql server developer edition.



I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved