Restore Problems


  • Hi,

    I try to restore (using Central Administrator) only one web application from production environment to development environment.

    When I try to do this, I receive this strange error :

    FatalError: Object wss_content_tst_temp (previous name: wss_content) failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     SqlException: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
    RESTORE DATABASE is terminating abnormally.

    I have checked sql version and sharepoint version, are the same versions...

    Could you please help me with this problem ?

    Thank you very much !


    Wednesday, March 29, 2017 1:40 PM

All replies

  • Can you verify that you have followed the below procedure?

    If so try following the steps below

    • Back–up content database from the Source SP2013SQL server and restore it in Destination SP 2013SQL Server.

    • Make Sure that the new Content DB has correct permissions (read & write).

    • In SharePoint Central Admin create a new Web Application, (e.g. ttp://application/sitename.

    • Open SharePoint Management Shell and run the command

      Test-SPContentDatabase -name <ContentDB Name> -webapplication http://application/sitename

    • This command will check the compatibility of the web application with the restored content database.

    • In SharePoint Central Admin, Navigate to Content Database settings, and remove any existing Content Databases associated with the Web Application http://application/sitename.

    • Now that you have a Web Application without a content database, you can now Mount the restored content database and attach it to the web Application.

      Mount-SPContentDatabase <Content Database Name> -DatabaseServer <Database Server Name> -WebApplication http://application/sitename

    Wednesday, March 29, 2017 2:17 PM