I have a content database with multiple site collections. Out of nowhere(as far as I am concerned) two site collections became inaccessible. I can't browse them(server or client), I can't delete them(when I select them trough the UI the selection returns empty).
I am a little lost in where to start here. Detach/attach database? Restore?
Edit: I did this query in the content database:
select * from sites
And it returned the expected number of site collections, but the two that are inaccessible are missing the field FullUrl
Doing this in powershell solved it:
$db = get-SpContentDatabase –identity $id $db.RefreshSitesInConfigurationDatabase()
I will leave the question open though, as I am not sure what causes this. Any hint would be appreciated. Also, for what I understand, the above command maps the site collections in a content database again, right?