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?