Posted by pb648174 on 09/30/71 11:45

After executing osql from the command line via the Windows scheduled
task interface, the following error is returned: "Timeout expired"

The code in the sql is as follows:


BACKUP Database DBName to DISK='D:\Files\Backups\DBName.bak' WITH INIT
go


Is the timeout happening during the backup or in just connecting to the

server? There is no firewall between the two machines they are on the
same hub, and the machine executing osql has SQL 2000 installed while
the database machine has SQL 2005.


The command line is:
print time
osql -b -n -E -S ServerName -i Backup.sql
print time

and the output is:

8:00a
Timeout expired
8:00a

Any ideas what the issue is? It happens intermittently, and works 98%
of the time. Typically when this happens, during the next backup it
will be fixed.

[Back to original message]