When trying to restore .bak file facing "Restore-SPSite : <nativehr> 0x00070003 </nativehr><nativestack></nativestack>"

And in the event viewer:

A database error occurred. Source: .Net SqlClient Data Provider Code: -2 occurred 0 time(s) Description: Error ordinal: 1 Message: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time.

How to fix this?

  • Can you also add the ULS log errors ? Commented Dec 7, 2016 at 7:11

2 Answers 2


When you restore a site from (assumingly) another farm you need to make sure that the destination farm is at the same patch level as the source farm. The destination farm can also have a higher (newer) patch level, but I've experienced failing to restore a site in this setup.

The easiest way to check is to run the following script on both farms, and verify the output.

  • Yes, you are correct. Destination environment is high version. So how should restore? thanks Commented Dec 8, 2016 at 5:49
  • @samdaniel Patch the source farm to the same patch level, and then backup->restore
    – Benny Skogberg
    Commented Dec 8, 2016 at 6:03
  • Is there any other way because I'm not allowed to do anything in source farm but have full control on destination environment Commented Dec 8, 2016 at 6:08
  • @samdaniel You could uninstall patches from destination farm instead, making both farms equal
    – Benny Skogberg
    Commented Dec 8, 2016 at 6:11
  • How to do revert patches and where to uninstall? in SQL? Commented Dec 8, 2016 at 6:34

Check in Event Viewer. Possibilities:

  1. SharePoint versions are different.
  2. Insufficient SQL Database permission for particular user.
  3. Managed path issue.


Try to restore with host header web application.

Restore-SPSite http://www.example.com -Path \\file_server\share\site_name.bak -HostHeaderWebApplication http://server_name

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.