MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Detail on MOSS databases?

  Asked By: Sampat    Date: Aug 09    Category: MOSS    Views: 1193

Can anybody point me to a web site or a document that does a good,
detailed job on explaining the database design for MOSS? We
recently installed MOSS and I have databases for Mysites, search,
config database as well as for our shared service provider.

There is a limited web page on MSDN that describes the tables and
columns in content and config databases for SPS 2003, but have found
nothing for MOSS.

For example, where is the actual URL stored for a mysite? Are URL's
stored in the config database? If not, then where?

In 2003, the sites table in the config db contained a row for each
site collection throughout the farm, but I do not see anything
similar in the MOSS config database. The config database seems very
lacking and I would just like to understand where everything is



2 Answers Found

Answer #1    Answered By: Nora Maxwell     Answered On: Aug 09

Microsoft doesn't typically publish anything about the database  because
accessing it isn't supported. Use the object model instead.

Answer #2    Answered By: Corina Duran     Answered On: Aug 09

Though it's not detailed, but a snapshot

<<<<<<<<<<<<<<<<<extracted from back and restore

The following are the databases  created by MOSS once MOSS is installed
and search  component is configured.





Configuration database

Configuration data for entire server farm.


Content Database

Content for the web  application.

Shared Services

Shared service  provider database.

Stores configuration settings for shared  service provider.

Shared Search Index

Search database  for Shared service.

Search database containing the property store and crawler history.

Search instance

Search database.

Search database for search server.

<<<<<<<<<<<<<<<<<extracted from back and restore

Apart from the above databases, a new content  database will be created
for each web application.

If you want to see the names of the databases in detail, refer backup
and restore admin screen, if you open this page, you can see list of
databases created and also names with explanation.

Didn't find what you were looking for? Find more on Detail on MOSS databases? Or get search suggestion and latest updates.