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(Iam74gibson@.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, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
No comments:
Post a Comment