Home Forums SQL Server 2005 Administering Clearing out msdb.dbo.sysmail_mailitems... RE: Clearing out msdb.dbo.sysmail_mailitems...
Summer90
SSC-Dedicated
Points: 32891
More actions
November 8, 2012 at 5:00 am
#1557118
There are several reasons for it. Typically the rows that are active are at the end of the file so it isn't shrinking. Rebuilding indexes on the tables will move the data to a different part of the file and then you should be able to shrink.