Processed 379 pages for database '_x_x', file '_x_x_Log' on file 1. [SQLSTATE 01000]
BACKUP LOG successfully processed 379 pages in 0.410 seconds (7.219 MB/sec). [SQLSTATE 01000]
BackupSetID = 1 for database '_x_x' [SQLSTATE 01000]
RESTORE VERIFYONLY FROM DISK = 'C:\MSSQL\Backup\x\_x_x_Backup_20190415150006.trn' WITH FILE = 1, NOUNLOAD, NOREWIND [SQLSTATE 01000]
The backup set on file 1 is valid. [SQLSTATE 01000]
End of Script [SQLSTATE 01000]
Test Linked Server Connection: \sqlexpress [SQLSTATE 01000]
OLE DB provider "SQLNCLI11" for linked server "\sqlexpress" returned message "Login timeout expired". [SQLSTATE 01000]
OLE DB provider "SQLNCLI11" for linked server "\sqlexpress" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance
name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". [SQLSTATE 01000]
Will either of the fix work?
Set the remote login timeout to 30 seconds, by using this code:
sp_configure 'remote login timeout', 30 go reconfigure with override go
Set the remote query timeout to 0 (infinite wait), by using this code:
sp_configure 'remote query timeout', 0 go reconfigure with override go
