Posted by: Shantham | March 10, 2009

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 used, all of the IIS Web sites, Web applications, solutions, Web Part packages, site templates, and Web application and farm settings specific to SharePoint technologies, such as default quota, blocked file types, and configuration. WSS3.0, MOSS 
WSS_Search_ComputerName This database is used for the search services. It contains the information that is required for searching content.By using this database, Windows SharePoint Search services enables users to search all Web site content on the server. WSS3.0, MOSS 
WSS_Content_GUID This database contains data specific to a Web application and its site collections. It contains the content data, such as the document uploaded to a list or a library. By default, a single content database is created for each Web application. All new site collections added to a Web application use the same database WSS3.0, MOSS 
SharedServicesN_DB Each Shared Service Provider (SSP) requires a database for service-specific data. MOSS
SharedServicesN_Search_DB In addition to the SSP database, a separate database is required for frequently changing search-related data. MOSS
SharedServicesContent This database is dedicated for the shared services content. MOSS
SSO This database stores the settings and account information for single sign-on. MOSS

For more informations, visit Windows SharePoint Services 3.0 ,  Office SharePoint Server.

Read more…

Advertisements

Responses

  1. Great post, clear and totally valid to know more about SharePoint databases.

  2. Hi, I’m working on getting informations with web services, especially the databases for each virtual server, i can get the guid of databases but not their names.

    So, is there a way to get the databases names with only web services?

    thanks!!

  3. I’m working from a machine where sharepoint is not installed, so it will be impossible for me to use stsadm comands

  4. I think, there is no predefined web services are available to get the database name and run stsadm command on remote server. If you want to do that, just create a custom webservices which handles those functions on SharePoint Server.

  5. […] 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 […]

  6. its very useful to know about sharepoint database…nice to learn..

  7. lovely article – easy to read and direct to the point. I found it very useful

  8. New Balance Shoes Shop ncryo.com for New Balance Shoes Cheap,New Balance Shoes Sale,New Balance Shoes On Sale,Cheap New Balance Shoes,New Balance Shoes Outlet,New Balance Shoes Shop with %56 off and free shipping.
    [img]http://www.ncryo.com/includes/templates/ncryo/images/brand/right02.jpg[/img]
    http://www.ncryo.com/


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: