I'm trying to restore SP 2013 public facing website from production to testing server. for this purpose I needed backup of web application and wants to restore the web application.
For this purpose I have taken the backup of web application from production server and copied that folder in testing env then created web application and top level site.
After that I tried to restore the site by using following command
Restore-SPFarm -Directory 'E:\Backup_20161225_040004' -RestoreMethod Overwrite -Item 'SharePoint-3810' -BackupId '85ac230b-b6b7-44e1-83d3-3e8c46a0c0bd' -Verbose
And when I checked logs I have found following critical errors
Unknown SQL Exception 258 occurred. Additional error information from SQL Server is included below. A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.)
And also getting following errors
12/26/2016 09:54:58.91 OWSTIMER (0x3324) 0x1DD0 SharePoint Foundation Upgrade SPUpgradeSession ajxme ERROR CanUpgrade [SPConfigurationDatabase] failed. 00000000-0000-0000-0000-000000000000
One more thing I want to clear
In our production server we have sql server 2008 where as in testing server sql server 2012.
So does it matters?
Please if anyone has idea then kindly tell me.