Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Content database management

  Asked By: Srikant    Date: May 07    Category: Sharepoint    Views: 1489

How can you tell what site collection is assigned to what content database? This is a WSS environment.



4 Answers Found

Answer #1    Answered By: Joanna Dixon     Answered On: May 07

Out of the box I am not aware of a quick and easy way to see which
specific site  collection belongs to which content  DB. You can see
which Virtual server belongs to which Content DB but can not drill
down to see top-level site collections. There is a third party tool
(free) that will let you see this.

It is quite a useful tool called SharePoint explorer you can check it
out here:

This tool will allow you to drill down into your site collections and
see as to what content DB it belongs to.

Answer #2    Answered By: Gopal Jamakhandi     Answered On: May 07

Locate your site  collection in the SITES table in the config database.
Using the associated databaseId, check the databases table in the config
database to see the content  database name.

Answer #3    Answered By: Christop Mcfadden     Answered On: May 07

The utilities in the WSSUserUtilies will also produce a report that will show you where site  collections are located.

Didn't find what you were looking for? Find more on Content database management Or get search suggestion and latest updates.