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 ? – Gautam Sheth Dec 7 '16 at 7:11

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 – sam daniel Dec 8 '16 at 5:49
  • @samdaniel Patch the source farm to the same patch level, and then backup->restore – Benny Skogberg Dec 8 '16 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 – sam daniel Dec 8 '16 at 6:08
  • @samdaniel You could uninstall patches from destination farm instead, making both farms equal – Benny Skogberg Dec 8 '16 at 6:11
  • How to do revert patches and where to uninstall? in SQL? – sam daniel Dec 8 '16 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, privacy policy and cookie policy

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