Hi, I am currently working with a Sharepoint Database on SQL Server 2005. There were a lot of records deleted(18,000 to 20,000 records or so) from the Sharepoint Database thru Sharepoint. They were deleted to clean up the database. I thought after the all those records were deleted and I ran Shrink Database the mdf file would decrease quite a bit and it only decreased a small amount. Is that accurate or should I have noticed a drastic change in size to the mdf file? I was thinking about a 25% decrease and it maybe decreased 2% or so. Any ideas? Thanks!

Try this http://www.mssqltips.com/tip.asp?tip=1777. 1. Create new DB. 2. Move site collection to new DB. 3.Remove old DB Oleg

when you deleted from sharepoint, did you check if those items are deleted from recycle bin? If they are in recycle bin, size will not decrease. On the otherside, size decrease depends on how much size data you have deleted, If you have deleted just list items, you will not see much difference. but your sharepoint list data had attachments or you deleted documents, then you should see a size reduction etc.Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)

Hi, yes the items were deleted from the recycle bin. The items that were deleted were list items with attachements/documents. How much of a size reduction should we see? Like I said above, we were thinking a 25% reduction and maybe only got 2% or so. Thanks!

Try execute a script on SQL Server: exec sp_spaceused This will show used and unused space in DB. Oleg