We are currently doing a 2010->2013 DB migration and attaching content databases back and forth. During the course of the migration I lost some notes on which content database belonged to which web application on the other end. These databases give no immediate indicator to where they were last attached to (someone gave them names of WSS_Content_<>). Is there any way (Microsoft supported or not) that I can investigate when they're merely attached and not mounted to SharePoint, any evidence of where they were attached too? I did find a table in the content database listing sites, but I'm not familiar enough with the underlying site structure to use this necessarily.

1 Answer 1


Since you mentioned "MS supported or not" , I am sharing this "non-supported" way of doing so.

Basically make a select * query to the table name [dbo].[DatabaseInformation]

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Name]
  FROM [WSS_Content].[dbo].[DatabaseInformation]

It will return a result like this

<AlternateDomains Count="2" Name="Yoursite collection name">
    <RedirectUrl />
    <RedirectUrl />

There you will find urls of the previous web apps contained within the database before it was detached and taken to a different farm.

  • Perfect, should be noted that a content database, when unmounted in SharePoint is likely ok with Microsoft to look at (if SharePoint can't see it yet...) but altering it would definitely be at your own risk...
    – tekiegreg
    May 23, 2013 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.