I have restored a copy of production db to our UAT SQL environment. When I run the Mount-SPContentDatabase, after 10 seconds I am receiving the successful message however When I checked the web-application there is not data. The content db size is around 90GB. Before it usually takes up to 30 minutes to Mount a database.

enter image description here

  1. Create a database via SharePoint.
  2. Dismount the database with powershell
  3. Restore the content to newly created db
  4. Using Powersehll to Mount database

enter image description here enter image description here

enter image description here

1 Answer 1


You may troubleshoot the below:

  1. Read the content database using PowerShell from the attached web application.
  2. Verify the size from the target migrated web application.
  3. If size is fine...Restart the server.

If above does not work, follow the below steps:

  1. Unmount the content database
  2. If you have AG group configured in database... make sure the primary listner (server) is always on.
  3. Restart the SQL service.
  4. Mount the content database back.
  • thanks SPM for your information, after following your suggestions I still have the issue, please read my comments.
    – Harris
    Jun 29, 2020 at 4:52
  • Do you create a new db in sql server and restore the content on that or do you restore the content on the db that was created with SharePoint web app?
    – Harris
    Jun 29, 2020 at 5:00
  • We need to restore the database then mount it to target web application.
    – SP 2022
    Jun 29, 2020 at 6:10
  • So you create a db using sql management or from SharePoint?
    – Harris
    Jun 29, 2020 at 6:12
  • Restore the database from sqlserver, then use the PowerShell mount command.
    – SP 2022
    Jun 29, 2020 at 7:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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