超时错误 [英] Timeout errors

问题描述

通过Windows预定的

任务界面从命令行执行osql后，返回以下错误：超时已过期


代码在sql中如下：

BACKUP数据库DBName为DISK =''D：\ Files \ Backups\DBName.bak''WITH INIT

go

备份期间或仅连接到
服务器时是否发生超时？它们位于

相同集线器的两台机器之间没有防火墙，并且执行osql的机器安装了SQL 2000，而数据库机器具有SQL 2005.

。 />
命令行是：

打印时间

osql -b -n -E -S ServerName -i Backup.sql

打印时间


，输出为：


8：00a

超时已到期

8：00a


任何想法是什么问题？它间歇性地发生，并且在98％b / b
的时间内工作。通常当发生这种情况时，在下一次备份期间它将修复

。

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.

推荐答案

pb648174（go **** @ webpaul.net）写道：

pb648174 (go****@webpaul.net) writes:

通过Windows预定的任务界面从命令行执行osql后，返回以下错误：超时已过期

sql中的代码如下：

BACKUP数据库DBName到DISK =''D：\Files \Backups\DBName.bak''WITH INIT
go


和D是SQL Server机器的本地磁盘？

备份期间或仅连接到
命令行是：
打印时间
osql -b -n -E -S ServerName -i Backup.sql
打印时间

输出结果为：
8：00a
超时已过期
8：00a

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
And D is a local disk to the SQL Server machine?
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

从消息判断，这是命令超时，但是没有

是有意义的，因为默认情况下OSQL没有命令超时。但是

可能有一些间歇性错误导致OSQL将

默认超时设置为0？ （因此ODBC的默认超时为30

秒。）


看到时间的秒数也会很有趣。 />
-

Erland Sommarskog，SQL Server MVP， es****@sommarskog.se


SQL Server 2005联机丛书
http://www.microsoft.com/technet/pro...ads/books.mspx

适用于SQL Server 2000的联机丛书
http：/ /www.microsoft.com/sql/prodinf...ons/books.mspx

Judging from the message, this is a command timeout, but that does not
make sense, as OSQL by default does not have a command timeout. But
maybe there some intermittent error which causes OSQL to set the
default timeout to 0? (The default timeout for ODBC as such is 30
seconds.)

It would have been interesting to see the seconds for the time as well.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

您好


什么是打印时间？您可能希望将其更改为echo％time％


John


" pb648174" <去**** @ webpaul.net>在消息中写道

news：11 ********************** @ v46g2000cwv.googlegr oups.com ...

Hi

What is print time doing? You may want to change it to echo %time%

John

"pb648174" <go****@webpaul.net> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...

通过Windows预定的任务界面从命令行执行osql后，返回以下错误：超时已过期

sql中的代码如下：

备份数据库DBName到DISK =''D：\Files \Backups\DBName.bak''WITH INIT
go

超时发生了在备份期间或只是连接到服务器？它们位于同一个集线器上的两台机器之间没有防火墙，执行osql的机器安装了SQL 2000，而数据库机器有SQL 2005.

命令行是：
打印时间
osql -b -n -E -S ServerName -i Backup.sql
打印时间

输出结果为：
8：00a
超时已过期
8：00a

任何想法是什么问题？它间歇性地发生，并且在98％的时间内工作。通常当发生这种情况时，在下一次备份期间它将被修复。

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.

对不起，它不是打印时间而是时间/ t


John Bell写道：

Sorry, it isn''t print time but time /t

John Bell wrote:

嗨

什么是打印时间？您可能希望将其更改为回显％时间％

约翰

" pb648174" <去**** @ webpaul.net>在消息中写道
新闻：11 ********************** @ v46g2000cwv.googlegr oups.com ...

Hi

What is print time doing? You may want to change it to echo %time%

John

"pb648174" <go****@webpaul.net> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...

通过Windows预定的任务界面从命令行执行osql后，返回以下错误：超时已过期

sql中的代码如下：

BACKUP数据库DBName到DISK =''D：\Files \Backups\DBName.bak''WITH INIT
go

备份期间是否发生超时或只是连接到服务器？它们位于同一个集线器上的两台机器之间没有防火墙，执行osql的机器安装了SQL 2000，而数据库机器有SQL 2005.

命令行是：
打印时间
osql -b -n -E -S ServerName -i Backup.sql
打印时间

输出结果为：
8：00a
超时已过期
8：00a

任何想法是什么问题？它间歇性地发生，并且在98％的时间内工作。通常当发生这种情况时，在下一次备份期间它将被修复。

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.

这篇关于超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！