By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Error 0: Timeout Expired HYT00 when trying to backup DB's

P: n/a
I am getting this error when I try to back up the larger DB's on my
server. The smaller ones back up ok. Is there a parameter I can change
to increase this timeout? I have gone into ODBC, Query Analyzer, and
SQL server properties and played around with some settings, but nothing
seems to work.
Any help is appreciated!

Phil

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(Ia*********@houston.rr.com) writes:
I am getting this error when I try to back up the larger DB's on my
server. The smaller ones back up ok. Is there a parameter I can change
to increase this timeout? I have gone into ODBC, Query Analyzer, and
SQL server properties and played around with some settings, but nothing
seems to work.
Any help is appreciated!


So from where do you run this backup?

The timeout is a client-side thing, and different clients have different
timeouts. Many run with 30 seconds which is the default for ODBC,
Enterprise Manager and many others. In Query Analyzer there is no
timeout by default. Neither is there any default timeout for Agent jobs.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.