Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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]
      ,[Value]
  FROM [WSS_Content].[dbo].[DatabaseInformation]

It will return a result like this

AlternateAccessMappingXml
15A2E8AE-A259-4FB1-A8FB-0C53552CE95E
<AlternateDomains Count="2" Name="Yoursite collection name">
  <AlternateDomain>
    <IncomingUrl>http://yourlastsiteurl</IncomingUrl>
    <UrlZone>Default</UrlZone>
    <MappedUrl>http://yourlastsiteurl</MappedUrl>
    <RedirectUrl />
  </AlternateDomain>
  <AlternateDomain>
    <IncomingUrl></IncomingUrl>
    <UrlZone>Intranet</UrlZone>
    <MappedUrl></MappedUrl>
    <RedirectUrl />
  </AlternateDomain>
</AlternateDomains>
Id

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

share|improve this answer
    
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 '13 at 15:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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