<< Site collection administrators vs. Site owners (full control) | Blob Cache explained >>

Get Content DB name from GUID

by dipbiswas 17. January 2010 12:12

Try to execute the following query when you are connected to the sharepoint_config database:

Select ID, Name from objects where properties like '%Microsoft.SharePoint.Administration.SPContentDatabase%m_nWarningSiteCount%'

This query will give you the overall content databases name and id recorded in your farm.

66ed6a0e-ce61-4194-8273-f6a9724802b0|0|.0

Tags:

Reference

Configuring and Customizing the Content Query Web PartContent Query Web Part. This web part allows you to show items from your site based on a query...Out of sync. Access denied. Event ID 5555, 7888, 1314One of the scenarios this happens is when someone renames a database and makes a site lock...Moving a site collection to a new content sourceHere are the steps to move a site collection (from within a web application) to a different content ...

Comments

1/5/2010 3:12:37 PM #

If you know the GUID of the database, use the following query

Select ID, Name from objects where properties like
'%Microsoft.SharePoint.Administration.SPContentDatabase%m_nWarningSiteCount%'
and id='<put the GUID here>'

dipbiswas

Add comment

Name*
E-mail* (Will show your Gravatar icon)
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

The opinions expressed herein are personal opinions and do not represent others' view in anyway. All posts are provided AS IS with no warranties, and confers no rights.

You are visitor#

Get Content DB name from GUID

Category