For Host named site collection, SPSite is null. When we are reading the database using Unattached database method.

Question

When we are trying to read the host names site collection using ConnectAsUnattachedDatabase through database via power shell. We are getting NULL for SPSite .

Here is the script : -  

$dbName = "My_WSS_Content" 
$dbServer = "My-W2K22-SS19" 

$ContentDb = Get-SPContentDatabase -DatabaseName $dbName -DatabaseServer $dbServer -ConnectAsUnattachedDatabase 

Write-Host $ContentDb.Sites.Count; 

foreach($name in $ContentDb.Sites.Names) 
{ 
     Write-Host $name 
} 

Write-Host '=============' 
foreach($site in $ContentDb.Sites) 
{ 
    if($site -eq $null) 
    { 
              Write-Host 'null detetced'  
    } 
    else 
    { 
        if ($site.HostHeaderIsSiteName) 
        { 
            Write-Host $site.Url 'is host-named'  
        } 
        else 
        {  
          Write-Host $site.Url 'is path based'  
        } 
    } 
} 

Output : -  

5 

/ 

/sites/Mobiles 

thinkpadhost.demo.com:26148 

thinkpadhost.demo.com:26148/departments/marketing 

thinkpadhost.demo.com:26148/IT/Server

 ============= 

http://gk3-w2k22-sp19:12204 is path based 

http://gk3-w2k22-sp19:12204/sites/Mobiles is path based 

null detetced 

null detetced 

null detetced 

Answer 1

Hi @Gaurav Kumar3 (CS),

Per your description, the issue should relate to the backend of the sharepoint 2019. Since we are unable to fix the issue, I would recommend you to raise a new ticket in feedback. Many features of our current products are designed and upgraded based on customers’ feedback. With requirements like this increase, the problem may well be released in the future. Thanks for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.