Sunday, November 25, 2007

SharePoint V3.0 databases

When you install Sharepoint V3.0 onto SBS 2003 using the recommended installation from Microsoft you will end up installing the WMSDE database that was mentioned in a previous post. This is typically referred to as the <SERVER>\Microsoft##SSEE SQL instance. Now of course you could manipulate this from the command line using the osql commands but if there is GUI interface why no use that? If you download the Microsoft SQL Management Studio and install that you can use a GUI to interact with the WMSDE Sharepoint databases.
So what do these databases do ? Well :
  • Sharepoint_AdminContent_<GUID> stores the information related to lists, document libraries, tasks and so so on of the Central Administration site.
  • Sharepoint_Config_<GUID> stores information about the configuration of your Sharepoint farm. Things like servers and their role are saved here. If the farm involves a multi server environment (with web front ends, content and search servers) then how the whole farm is configured is held here. BY default each server in the farm checks with the configuration database every 30 seconds.
  • WSS_Content contains information related to lists, document libraries, tasks, wikis, blogs, structure details, security information and so on for your Sharepoint user site.
  • WSS_Search_<Server> contains search metadata, history log, search log and so on that is used for the inbuilt Sharepoint search functionality.
Remember there is only a limited amount of things you can do with the SSEE instance but the GUI certainly makes it easier and now at least you have some idea as to what each database does!