Posted by Shantha Kumar on 29th October 2009
0

SharePoint 2010 Search Databases

We have two new databases for Search Service in SharePoint Server 2010 when compared to MOSS2007. One for Administration purpose, another for Crawling and other one for storing crawled contents, which is already available in MOSS 2007 .
In MOSS 2007, SSP database contains the search administration settings and Crawler information. But in SharePoint Server 2010, [...]

Posted by Shantha Kumar on 18th March 2009
0

SharePoint Database SQL Query Tips1

Today onwards on daily basis, I decided to post the Sql Query to access the SharePoint Databases. To know more about the databases in Sharepoint , check my SharePoint Databases Post.
To retrieve all lists from the database, use the following query,
select AllLists.tp_Title as ‘List Title’,webs.Title as ‘Web Title’
from dbo.AllLists as AllLists
inner join dbo.Webs as webs
on [...]

Posted by Shantha Kumar on 10th March 2009
4

SharePoint Databases

I did some research on SharePoint Databases and how are they providing datas to SharePoint sites?. Here i am come up with some details of Databases used in SharePoint.

Database Name
Description
Availablity

SharePoint_AdminContent_
GUID
This is the Central Admin Content database, is used to store all WSS 3.0 / MOSS content.
WSS3.0, MOSS 

SharePoint_Config
The configuration database contains data about all the databases [...]