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.
Great post, clear and totally valid to know more about SharePoint databases.
By: sharepointuzma on March 10, 2009
at 5:22 pm
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!!
By: siham on March 12, 2009
at 4:48 pm
I’m working from a machine where sharepoint is not installed, so it will be impossible for me to use stsadm comands
By: siham on March 12, 2009
at 4:52 pm
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.
By: Shantha Kumar on March 14, 2009
at 6:45 am
[…] 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 […]
By: SharePoint Database SQL Query Tips1 « Welcome to ShanthaKumar’s Blog on July 2, 2009
at 10:28 pm
its very useful to know about sharepoint database…nice to learn..
By: sathya on November 11, 2009
at 4:20 pm
lovely article – easy to read and direct to the point. I found it very useful
By: Olu on January 18, 2010
at 5:57 pm
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/
By: werBroons on November 3, 2013
at 6:27 am