SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored database name. The root site works fine but when i click on a sub site i get a 404 error for all sub sites and site content. I have been searching for 3 days now. Any assistance would be greatly appreciated.

share|improve this question
  1. Delete your web application.
  2. Create a new one. Take care that the authentication mode is identical with the initial web application in which your backed up site collection has been created. Do not directly assign your restored content database but let Sharepoint create a new (empty) content database.
  3. Next, from your Central Administration => Application Management => Manage Content Databases => select the content database which has been created in step 2 => Remove content database => OK. Please note, that the content database now is removed from your web application but not yet deleted on your sql server. delete it manually from the sql server (i. e. via sql server management studio).
  4. Restore your backed up content database to sql server.
  5. On your Sharepoint server run the following statement via Sharepoint Management Shell:

    Test-SPContentDatabase -Name "your_db_name" -WebApplication "name_of_your_webapp"

    Are there any errors listed? Try to resolve them.

  6. Run the following statement via Sharepoint Management Shell:

    Mount-SPContentDatabase "your_db_name" -DatabaseServer "your_sqlserver" -WebApplication "name_of_your_webapp"
  7. Now try to access your site with administrative and non-administrative accounts. If necessary change the authentication mode of your web application. Don't forget to set portalsuperuser and portalsuperreader accounts.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.