Add Content DB in Site

[Vu Manh Tai]

Hi ALL
I add a content DB in my site but i see Current Number of Site Collections = 0 

How do i fix it

[#2]

How did you add the Content DB in the farm?

[#3]

Hi Juan
i follow step on the link:
https://docs.microsoft.com/en-us/sharepoint/administration/attach-or-detach-content-databases

[#4]

If you follow the procedure documented there, then you should be good with the attaching process...how many site collections do you have in the original SharePoint Farm where you detached the Content DB?

[#5 · Accepted solution]

A few things to consider :

1. How did you reattach the content database? Did you run "stsadm -o addcontentdb -url http//[URL] -databasename WSS_content"? Try that , if not already done.

2. Is the version of the content database you mounted and farm content database the same? If not, please upgrade both servers to the same built number.

3. If nothing of the above works , then try below :

$app = get-spwebapplication –identity “url of the problem web app”
$app.contentdatabases.count

Run SQL query 

$db = get-spwebapplication –identity “url of the webapplication that had the null entry” 
$db.contentdatabses.delete(“guidOfProblemDb”)

If you get null reference exception, then run the following command.

$db = Get-SPDatabase -Identity "guidOfProblemDb"
$db.Delete()

Update site map table in Config DB :

$db = get-spcontentdatabase -Identity [insert guid of cdb here]
$db.RefreshSitesInConfigurationDatabase()

[#6]

thank you so much

[#7]

Let us all know what solution worked for you