.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Content Database Purge ?

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :SharePoint
  I just made an experiment: created new web app created new site collection put there a doclib1 with 5 Gb of pdf documents checked size of content db in sql studio - it was 5.5 Gb with 300 Mb available (free, but reserved space, that can be redeemed with shrink operation) Then i deleted doclib1 Then i cleaned recycle bin (2 level), so on this stage the data is totally deleted on site level with no restoration options Checked the db - 5.5 Gb (which is normal) with 800 Mb available. Why 800 Mb and not 5 Gb ? Why i can redeem only 500 Mb in the end ? Are sharepoint content dbs are even made for redeeming space after some of its contents are deleted ?

View Complete Post

More Related Resource Links

How to get access to content database after server hardware failure


Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.

Victor Naranjo MCSE + Security MCSA + Security MCSE + Messaging MCSA + Messaging ITIL Certified Comptia Security+

MOSS Content Database has more documents than what's seen on browser

I am not sure how sharepoint internally handles stuff, but this is what I see. I am a SQLDBA and one of my company sharepoint group re-organized a site, by moving some files from a document library to another document library. I think she used the content deployment.

When she see the number of documents in the document library it showed 700 documents. She moved only 50 of them. I went into the database and queried the Docs and DocStreams View and I get the list of all the those documents. I see both the ones that we see on the site as well as something that we do not see on the site.


ad.DirName, ad.LeafName, TimeCreated, ads.size/1024 as [Size(KB)], SetupPath

FROM Docs ad, DocStr

Estimate weight of BLOB data in our content database

How can I estimate overall size of blob data?

SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

Cannot create content database: The specified SPConfigurationDatabase Name=SharePoint_Config Parent=

Guys, This is the farm configuration: 1. SQL Server 2005 back end server 2. WSS 3.0 / MOSS 2007 WFE Server 3. WSS 3.0 / MOSS 2007 Index/WFE Server All servers are showing the version: in 'Servers in Farm' in C.A. When attempting to add a new content database, the following error is thrown in the web UI: The specified SPConfigurationDatabase Name=SharePoint_Config-New Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object. Furthermore the following is posted to the application event log on the WFE hosting central admin: Database 'SharePoint_Config-New' on SQL Server instance 'XXXXXXXX' is not empty and does not match current database schema. There is nothing of further interest in the trace log, just the same error as above. No errors on the SQL server either. Also no updates have been installed, and content databases HAVE been created since the last updates were installed 2 years ago. Can anyone suggest anything before I raise a call with MS? I have checked permissions for the sharepoint system account on the databases and all seems fine. Cheers, Conrad    Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

How to get previous version of content database

Hi,   Setps I did.... 1. Created Site collection with url http://server.80/Site1 2. taken the back up of dev server site collection and trying to restore with this new site collection 3. But, i restored in http://server.80/ How to get the content databse back up of http://server.80/  Pls its very urgent......................   Thanks in Adv..................

after restoring content database getting error (HTTP/1.1 200 OK Server: Microsoft-IIS/7.5 Date: Tue,

Hi All, Problem i have taken backup of Old site content database procedure see below 1) first i changed the database to read only mode (Opened SQL Server2005-->selected DB--> properties--> Option-->Database Read-Only=True) 2) taken backup of database from the task--Backup(new.bak) 3) Copied the taken backup to new server and restored (Opened SQL Server2005 --> Right Click on Database Folder--> Restore Dataase) In To database: ihave given DB name From Device: i have selected database from the location where i have saved. click ok.  It has restored successfully 4) I have created a new webapplication and removed its content database from central admin. 5) with the help of stsadm command i restored the above db to this webapplication. then iam getting below error: HTTP/1.1 404 Connection: close Date: Tue, 14 Sep 2010 06:20:08 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: i have refered the below url for restoring http://metahat.blogspot.com/2008/11/backup-restoring-sharepoint-2007-site.html Please help. Thanks in advance.

Database design for treeview and content

HiI"m student and need help to design a database for treeview and some content.I need a database design with treeview and it's childnodes,  different content for each node, and modules for each page, like search, contact form and etc... with ability to turn it on and off.Maybe you can show me the way or maybe you have some good links for database design. Any help would be appreciated.THANKS

Powerhsell script for MOSS 2007 to get content database size



Can you please provide me a script to get content database size in MOSS 2007.




After adding the content database, i could see the Current Number of Sites are zero.


After adding the content database, i could see the Current Number of Sites are zero.

Its should be 5, but its hsowing me 0,

what i need to do for this 

Move Single MOSS Content Database to Different SQL Server

We want to mmove the single database of MOSS on Network Test and Development to the Production SQL Server. But MOSS aplication server remains same!

So in this condition it points out for the two database servers at the same time.

Is it possible? Or I need to migrate the all concern databases to the another SQL Server?

Pls HelP!

Crawling does not happing on a content database from set of DBs of my Web Application (MOSS)


Hi Team,

This is regarding indexing in MOSS content sources. I have an MOSS application(web site) configured as Content source for crawling. A user reported that his is not able to search on the content uploaded to his site. After performing quite a few checks and investigatations. We found below info in crawl log, we suspect that this is  crawling of all sites in Content Database(i.e., non are crawled and searchable). Atleast that is what we understand by trying search of quite a few sites residing in the databse.

Exception from HRESULT: 0x81070504 (There is no Web named "/sites/020045t".)

Also we find the site only in SiteMap table in SharePoint config Database only. We tried deletesite command with -force and -siteid switch, both were unsuccessful. Can someone tell us how to remove this orphan site/ entry in sitemap table? We are hesitent to delete the row in sitemap table since we do not impact of doing it from backend.

Thank you,


how to insert data into database from content page?


Please help me to insert data to database from a content page of a master page. My code is working fine when i use my code without master page but with content page of master page i dnt knw what goes wrong. Help me on this please.

thank you

Restoring a Content Database to an earlier MSSQL backup?

We'd like to roll back a content database to an earlier point in time. Is this doable by just shutting down the frontend, and then restoring the MSSQL WSS_Content database, or are there some quirks that we need to take into account?

How to save WPF RichTextBox content (text + image) to the database



I want to save (and after that also to retrieve) the content of an WPF RichTextBox (text + image) to/from the database.

I found this: http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/750a654e-b002-4742-8f46-609e93f6ec81 but like the author said, the solution seams not to work for text with image - the image is ignored/removed and only the formatted text is saved and after that retrieved to/from database.

Know someone a solution about this issue?

Best regards,





Delete a Site Collection without a Content database


I have a site collection whose content database has been deleted with no backup. Now I want to delete the site collection and i get what seems to be a sql login error. I know the account I am using has enough access to the sql server (used this account to install sharepoint). I am guessing it is complaining because it can't find the database.

Remove-SPSite : Cannot open database "WSS_Content_Database" requested by the lo
gin. The login failed.
Login failed for user 'DOMAIN\PowerfulAccount'.
At line:1 char:14
+ Remove-SPSite <<<<  https://sitename.domain.com/mysite/username
    + CategoryInfo          : InvalidData: (Microsoft.Share...mdletRemoveSite:
   SPCmdletRemoveSite) [Remove-SPSite], SqlException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSi

I used the Remove-SPSite <URL of site to delete> command.

Any ideas?

Thanks, Berney

Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend