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

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

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

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
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

View Complete Post

More Related Resource Links

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.




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,


Content Types in MOSS 2007

In this article I will try to describe the one of the best feature in Microsoft office Share Point 2007 called Content Types.

Content types are simply collection of contents.Each content in a Content type can have different settings.Basically it is a reusable collection of settings which you want to apply to a particular category of contents.

Browser detection and content adaptation


hi everyone

 Here i'm creating two sites for internet version and mobile version.

 When the user enters site name, we would detect the mobile browser automatically and redirect the user to mobile version of the site .

is it possible??

if yes, please tell the way i need to develop the application for mobile web application

SharePoint and Open XML: Generating Documents from SharePoint Using Open XML Content Controls


This article describes how to generate documents that contain data stored in SharePoint lists. The example demonstrates how OpenXML content controls can be defined to capture list data in a Word document and how LINQ to XML can be used to query the lists. The documents are generated from a SharePoint Web Part.

Eric White

MSDN Magazine October 2009

WPF: Flexible Content Display With Flow Documents


Markus Egger discusses all the flexibility and power of flow documents in Windows Presentation Foundation

Markus Egger

MSDN Magazine August 2007

Toolbox: Database job scheduling, Browser Analysis, and More


From a developer's perspective, once a database's schema has been defined and the tables, stored procedures, and other database objects have been created, it can be forgotten, abstracted away into the data access layer of the application's architecture.

Scott Mitchell

MSDN Magazine May 2006

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+

Reg: Turn on more accessible mode & Skip to main content link message on Infopath2007 browser form



I have a infopath 2007 browser enabled form with c# code behind . The Infopath form is embeded\hosted in to a custom layouts page (.aspx) on MOSS 2007. The issue is when users use keyboard to fill the form, they often use <TAB> & <Enter> keys. So when they are using the tabbing at one location in the form, I have a "Contact selector" field, I enter a name & then hit <TAB> key the focus now comes to "name cheker" I then hit <Enter> key, I hit <TAB> again, the focus now comes to a button named "Accept", I hit <Enter> key & a filed below is populated with the values from user profile service. Now when I hit <TAB> I expect the focus should now come to that automatically populated field below the "Contact selctor". Because Infopath assings the tab order by default form top to bottom & left to right and I havent changed that default tab order.   

But, the focus moves to top of the webpage with a clickable link to "Turn on more accessible mode" I hit tab one more time & the link on top changes to "Skip to main content". This bheaviour does not seem to be happning in other form controls when they hit <Tab>, <Enter>. There are couple of areas on the infopath form where I have such a controls (layed ou

Estimate weight of BLOB data in our content database

How can I estimate overall size of blob data?

Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

Record Center and content type of the incoming documents


Hello all

I have same content types in both collboration site and record center sites.

When I used Send To command to send a document from collaboration area to record center, all the properties and metadata are promoted to columns in the Record center library. But the Content type of the document in record center is set to "Document" even though the incoming document's metadata has Content type value. Will all the records end up as Document content type if we are using default router?



Kiran Bellala

Uploading documents directly to record center libraries in MOSS


Hello all,

We have several pdf documents that are records and we want to maintain them in record center. These documents were not part of any collaboration sites. They are all in a shared folder. So there is no audit history and version history for these documents which is typical of any collaboration area documents.

The question I have is, will there be any disadvantages of directly uploading the document to record center library instead of setting up routing rules and submitting the document using OfficialFile.asmx.

I have noticed that when we submit a document using Send To, Record Center's default router renames the file and makes it a unique file name by appending _uniqueId. In my case, all the files are uniquely named and I am not worried about file name clashes.

Is it advisable to directly upload the documents to record cente

Search content of different languages in one language of MOSS

Hi, Hope you guys can help to answer this Search question. E.g. English MOSS is installed, content in English, Traditional Chinese, Simplified Chinese and Japanese are input to the system (either in Word/Excel file, ASPX page, Blog entry or Wikis page). In this case, how can the user search content by entering search keywords in languages other than English? The reason I ask this question is that: MOSS Search Engine uses English work-breaker/stemmer in the crawling and query process in MOSS English Version. Then, it cannot distinguish which languages are being crawled, e.g. pretending Japanese and Chinese as English when crawling the content. Is there any advanced way to solve this issue in MOSS 2007, besides installing various languages of MOSS in different servers? This problem exists in SharePoint 2003, so now I wonder if there is any improvement in 2007. As you know this is especially important in HK environment. Every customer ask the same question in Pre-Sales demo. Thanks in advance. Paul

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.

SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.
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