Skip to Content
0
Jan 04, 2011 at 07:09 AM

MSDB Issue

36 Views

Hi guys,

A client of ours has almost no available space on the C:\ drive of the server. All SAP databases are on another partition. It has been found that the database MSDB in SQL is over 7 GB. I found this query and ran it on the database:

select sum(reserved)/128 as "Size in MB", object_name(id) as "Object Name"

from sysindexes

where indid in (0, 1, 255)

group by id

order by 1 desc

It turns out that there is a table called "queue_Messages_551673013" that is over 7GB in size. Is there anything that can be done about this?

Thanks,

Costas