6GB Msdbdata.mdf
May 14, 2007Hi 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