Saturday, October 20, 2012

SharePoint AAM Storage Location

Recently, I had changed the AAM on the production farm. Shortly after I rolled back the configuration database but alas the old settings were still there.

I desperately began looking for the storage location of the AAM settings. I found very little information on google and thought that it would be good to post regarding this issue. Fortunately microsoft does have a KB article on the matter, but it was not easy to find.

So a little extra under the bonnet information when it comes to SharePoint. The AAM configuration does live in the Configuration Database, so why didn't it update on restore?

The answer lies with the WFE which also caches these values, Central Administration also displays the values from the cache and not the configuration database...In the event that they are out of sync you need to nuke the WFE by deleting the cache folders and allowing them to rebuild/refresh. Then your new settings will apply.

Also I found that whilst this was an issue I could not change the AAM settings, this is where I found the KB article.

http://support.microsoft.com/kb/939308

The database stores only one XML string for each application containing the AAM configuration.

The following SQL queries will let you find the Alternate Access Mapping settings in the configuration database stored in the table dbo.Objects:


SELECT

[Id],[ClassId],[ParentId],[Name],[Status],[Version],[Properties]
 FROM [StaffNetTest_ConfigDB].[dbo].[Objects]
 Where Properties like '<object type="Microsoft.SharePoint.Administration.SPAlternateUrlCollection%'
GO

No comments:

Post a Comment