> 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.

> osql -b -n -E -S ServerName -i Backup.sql
>
>
> We use a single backup server that not only connects to all the various
> databases and backs them up, but also copies the .bak files to another
> drive, copies application files to a backup area, zips them up, etc.
>
> I think this is related to another issue I see on some client's servers
> where the web server intermittently cannot talk to the SQL server..
> This error also happens intermittently. I have never figured out what
> the issue is so I ping the newgroup every now and then hoping someone
> will have seen it themselves. My guess is that it is network related.