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.
|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.
March 10, 2009 at 5:22 PM
Great post, clear and totally valid to know more about SharePoint databases.
March 12, 2009 at 4:48 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?
March 12, 2009 at 4:52 PM
I’m working from a machine where sharepoint is not installed, so it will be impossible for me to use stsadm comands
March 14, 2009 at 6:45 AM
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.