Hi We are running MOSS 2007 with SQL server 2005 . I deleted second stage recyclebin items for my site collection but didnt get any free space in the disk drive of db server. I came to know that sharepoint allows to execute delete command in the db server but not truncate which will not free up the disk space. Then, how could we get the free space in the server to continue the business operations on the site without adding new disk space to the drive? Should i follow up the DBAs to shrink up the files in the sql server? Should I shrink the log files enough or content too? Thanks, AnilANIL

Hiya, You should check the database too see how much space is free. In both data and log file. Secondly its important to check if your running Full or Simple recovery mode on the database.

Hi AnilKrishna, After you have deleted the items in your second stage recyclebin, the associated rows in the database are deleted. You will not see the free space until you shrink the data file and the log file as the deleted items will have left fragments in the hard disk. Hope this helps. Regards, JeremyJeremy Ramos | .NET / SharePoint / Dynamics Developer

Hi, Never execute any delete statement on your sharepoint DB. This will withdraw the support from MSFT. You need to shrink your DB files.Thanks, Rahul Rashu

Hi, Never execute any delete statement on your sharepoint DB. This will withdraw the support from MSFT. You need to shrink your DB files.Thanks, Rahul Rashu

Hi AnilKrishna, After you have deleted the items in your second stage recyclebin, the associated rows in the database are deleted. You will not see the free space until you shrink the data file and the log file as the deleted items will have left fragments in the hard disk. Hope this helps. Regards, JeremyJeremy Ramos | .NET / SharePoint / Dynamics Developer