Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Thursday, August 24, 2017 9:16 PM
Is there a way to connect an existing content database that has zero site count to a current SharePoint that will allow the data from the old content database to be shown. I have tried export via Central Administration then import using PowerShell to retrieve the information, but I get an error to the effect of SharePoint Version Miss Match. I am thinking that is caused by not running configuration wizard on our SharePoint environment. Is there another way to have a content database connect to a SharePoint site and display the contents of that database.
R/ Art M
All replies (7)
Sunday, August 27, 2017 6:03 AM ✅Answered
Hi Arthur,
Are there any customization on your old content database. You have to deploy those webparts or solutions on new farm before attaching it to the new farm or else you have to remove those before attaching the content db.
Please find the below articles which will help you:
http://get-spscripts.com/2011/08/diagnose-missingwebpart-and.html
SAGAR PATIL
Monday, August 28, 2017 2:40 PM ✅Answered
you need to install the same wsp packages from old farm to the new one before to mount content database. Here is PowerShell script which will export all wsps from the farm: Extract wsp packages which are currently installed in the Sharepoint solution store via PowerShell. After export copy them to the new farm and install using Add-SPSolution and Install-SPSolution cmdlets.
Blog - http://sadomovalex.blogspot.com
Dynamic CAML queries via C# - http://camlex.codeplex.com
Friday, August 25, 2017 9:22 AM
Hi Arthur M,
No, we need to resolve the content database shows 0 site collection issue.
Please run the Test-spcontentdatabase command to test a content database.
Besides, check the ULS log and Even log and try to find more error message about this issue.
Here is the information about attaching content database. Please check whether you have attach the content database correctly.
https://technet.microsoft.com/en-us/library/ff628582(v=office.14).aspx
Best Regards,
Linda Zhang
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]
Friday, August 25, 2017 3:06 PM
hello
how exactly you checked sites count? Did you execute Sql query
select * from AllSites
or saw it in UI. If you checked sites count from Sql query and it returned 0 why do you think that this content database will contain any data?
Anyway in order to attach content database to Sharepoint web application you should use either Central administration or Mount-SPContentDatabase cmdlet: Attach or detach content databases.
Blog - http://sadomovalex.blogspot.com
Dynamic CAML queries via C# - http://camlex.codeplex.com
Friday, August 25, 2017 3:39 PM
I did not expressly check site count, when I ran the Mount ... command it returned a result and in the result it will show sites, mine unfortunately showed zero. I have tried to export content then create a new site collection based on the export only to have it fail. I know it has content looking at the different tables available at least I think it does.
R/ Art M
Friday, August 25, 2017 3:53 PM
First time I ran the test-spcontentdatabase I received a login failure, it was my mistake to leave off the -ServerInstance. After running the test... I have several missingwebpart items, next is looking into how to either fix or call it a day for that data. I will look into the ULS logs and see what value is there.
R/ Art M
Monday, August 28, 2017 8:11 PM
Thank you for the answers both helped. Thank you for taking the time!!
R/ Art M