Solved

Database Size is not reducing after empty Recycle bin in SharePoint 2007.

Posted on 2012-12-26
3
1,208 Views
Last Modified: 2012-12-28
Hi, in one site collection I have deleted recycle bin data even deleted from secondary recycle bin also but mdf file of that site collection database is still showing the same size, it is not reducing.

Kindly suggest.
0
Comment
Question by:Minesh Shah
3 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 38722889
the .mdf file of sql server database will not shrink just because you delete data in the tables, and not even if you just dropped tables.

you would need to explicitly request to shrink the data files (or even the full database), which you can do in sql server using the GUI or t-SQL, but normally, you just won't.
the exception is if your database files had grown just "out of control", so you have to reclaim disk space.

normally, you would just keep the file sizes as are. sql server will internally reuse the space.
0
 
LVL 13

Accepted Solution

by:
Yagya Shree earned 250 total points
ID: 38723458
Hi MineSharePoint,

Angel is right on pointing out the fact that the database will not reclaim the space even if you cleanup you recycle bin in sharepoint.

From the sharepoint, point of view, you have to manually perform Db shrinking for which you can follow methods mentioned in the below post

Shrinking a Database
http://msdn.microsoft.com/en-us/library/ms189080(v=sql.105).aspx
0
 
LVL 10

Author Closing Comment

by:Minesh Shah
ID: 38726325
thanks, now it is redused by srinking
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question