|
|
Posted by pb648174 on 10/02/39 11:45
Sorry, it isn't print time but time /t
John Bell wrote:
> Hi
>
> What is print time doing? You may want to change it to echo %time%
>
> John
>
> "pb648174" <google@webpaul.net> wrote in message
> news:1145380471.168459.108470@v46g2000cwv.googlegroups.com...
> > 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.
> >
Navigation:
[Reply to this message]
|