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 \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_ stores the information related to lists, document libraries, tasks and so so on of the Central Administration site.
  • Sharepoint_Config_ 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_ 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!

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s