I've inherited a SharePoint site as sql .bak file. I took the following steps to create the site:
- Create a Web Application
- Create a root site (no template)
- Delete the default database:
Remove-SPContentDatabase -Identity "WSS_Content"
- In SQL Server Management Studio, restore the .bak file to a db named "WSS_Content"
- Associate restored db with application:
Mount-SPContentDatabase "WSS_Content" -DatabaseServer "\SharePoint" -WebApplication http:// my-root-site
I also have a Managed Metadata sql db .bak file and a sql .bak file for a 3rd party user management tool (Extranet Collaboration Manager). I have not restored these to the new site. I thought I'd focus on the content first. Noting it here in case it sheds light on the problem.
Problem 1: I am unable to select my root site in Central Administration. For example, if I navigate to Application Management > View all site collections selecting the root site does not display any information on the right hand side.
Problem 2: I am unable to change the site administrator, it claims the user does not exist.
I've searched the powershell commands and forums to figure out what else I should be doing, but am too new to SharePoint to understand my problem fully. Have I followed the correct steps to create a site from a SQL .bak file?
Per Russell's suggestions below I have:
- Confirmed the new database is listed in central administration.
- Confirmed the number of sites I would expect, in this case 1.
- Content DB Version had a status of Database is in compatibility range and upgrade is recommended. I ran
Upgrade-SPContentDatabase -id "WSS_Content"and now the status is No Action required