How do you free up your Content database as it grows bigger?

By -
I had one of my customer having more than 48GB on the content DB.

After couple of search, I found the following method that worked for me:

1. Empty your sharepoint Recylce Bin (This actually gets you a lot of space) - Navigate to you Recycle Bin in two ways

http://yoursite/_layouts/AdminRecycleBin.aspx
http://yoursite//_layouts/storman.aspx

2. Defragment your content DB : Defragmentation of the database keeps the data organized.  If you have installed Service Pack 2, then this happens automatically.  If you have not installed Service Pack 2 then there are instructions for how to do this.  http://support.microsoft.com/kb/943345  


3. Shrink the DB - A shrink reduces the size of the database.  If there is a very large amount listed reported as "space available" when you right click on a database in SQL Server Manager and look at properties then you may want to perform a shrink on the database.  Note: The content db grows as data increases. It never shrinks. So, even when you empty the recyclebin, the size of the db won't be reduced though it's the unused space. So, to free up the unused space, we have to shrink the DB. However, it's not a good idea to shrink a DB very often.

The above provided me nearly 20GB which is half of the actual space.

Comments

Anonymous said…
This piece of writing will assist the internet people for
building up new webpage or even a weblog from start to end.


Feel free to surf to my website ... diet plans that work
my web page :: diets that work
6:46 AM
Anonymous said…
Very shortly this web site will be famous among all blog users, due
to it's nice articles

Also visit my site :: egyption statues
my page > fetishfrolicflirt.com
10:24 PM
Anonymous said…
For men who were given a daily dose of such oral
medication, side effects of the 50 mg farmacia on line were more pronounced than
on its latest handset. 5 per cent of people farmacia
on line doesn't work for are going to be in the new commercials. When the app debuted last year, and raising money via online ads has proved notoriously difficult for most companies.

Visit my weblog com.ua
1:01 AM
Post a Comment

Popular posts from this blog

Linksys Wireless Connection Failure

By -
I configured the Linksys wireless router [WRT54G] couple of years before and it just worked great. I myself configured the password and everything worked great at my home. Anyone comes in home takes my password and it just worked great most of the time. all these were with windows server 2003 and Dell machaines. When I bought a new Hp DV9000 (XP) I had an issue connecting to the home wireless. I started browsing and found this solution: Issue : Couldn't connect to the selected connection. 1. Installed an update http://www.microsoft.com/downloads/thankyou.aspx?familyId=17d997d2-5034-4bbb-b74d-ad8430a1f7c8&displayLang=en Issue after the update : Acquiring Network address status and stayed there. Did the following after that: 1. Browsed http://192.168.1.1/ 2. used the user-id / password of the connection (default userid is empty & pwd is admin) 3. Navigated to wireless (Basic wireless settings), click Reset security and name your userid for SSID 4. Clicked save settings 5. cli...
Read more

The security validation for this page is invalid. Click Back in your Web

By -
If you are getting the following error, while renaming the page title using publishingpage object " The security validation for this page is invalid. Click Back in your Webbrowser, refresh the page, and try your operation again ." Code Snippet: PublishingWeb publishingweb = PublishingWeb.GetPublishingWeb(newUri(" http://YourPortal/Plans/ ")); PublishingPage pp =publishingweb.GetPublishingPages()["Pages/TestArticle.aspx"]; pp.Title = e.Node.Text; pp.Update(); You should check for this : Navigate thru the followwing and turn the security validation Off Central Administration--->application management---->web application settings-->"turn security validation off"
Read more

Access Denied Host Header Sharepoint 2010 Windows Server 2008 R2

By -
If you are running into a weird issue, where you get prompted for your credentials repeatedly in your local sharepoint server and was denied access to the site, even though you are using an administrator account, and if this happens only when you create a nice host header and on 80 port, then you are here at the right place - Just read the below. Method 1 works for me :  Click  Start , click  Run , type  regedit , and then click  OK . In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0 Right-click  MSV1_0 , point to  New , and then click  Multi-String Value . Type  BackConnectionHostNames , and then press ENTER. Right-click  BackConnectionHostNames , and then click  Modify . In the  Value data  box, type the host name or the host names for the sites that are on the local computer, and then click  OK . Quit Registry Editor, and th...
Read more