Unable to restore Sharepoint 2013 web application from produ

Hi guys, Hope everyone is doing well.

our public facing website has developed in sp 2013, I want to restore the web site from production to testing.

Basically we have one web application in production and that application has 2 site collections, thus the reason I have taken the backup of web application from production server using powershell and copied the folder in testing environment.

and created new web application in testing environment and then created a site collection, then tried to restore using following powershell command

Restore-SPFarm -Directory'E:\Backup_20161225_040004' -Restoremethod Overwrite -Item 'SharePoint - 16568' -Verbose

and I'm getting following error

And in log files I'm getting following errors related to databse

Cannot connect to SQL Server. 10.0.7.11 not found. Additional error information from SQL Server is included below. 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. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=15921;

12/30/2016 18:24:30.87 OWSTIMER (0x1B84) 0x28BC SharePoint Foundation Upgrade SPUpgradeSession ajxme ERROR Exception: 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. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=15275; 1628c69d-d002-7017-4531-85c6d0baef70

But I'm still able to view existing sites and can create new web applicatios and all..

May I please know why I'm getting this error and how to resolve it.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manpreet Singh9y ago
Hi,

Firstly try to create a test site collection and check if the site collection is opening or not.

Manpreet Singh
Microsoft MVP
Find me here - https://sharepointworldbymanpreet.wordpress.com/
Samarendra Swain9y ago
For restoring only two sites from Production to Test Farm, you could simply take the backup the content database from Prod and restore it in Test farm. Then provide the DB owner permission to Test farm service account and attach it to Test Farm in any web app.

SQL backup and restore are easy in this case.

But if you are restoring a complete farm, you need take care of the permissions properly.