|
Home > Archive > MS SQL Server > September 2005 > "Timeout expired" errors
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
"Timeout expired" errors
|
|
| PKSpence 2005-09-28, 8:23 pm |
| User is getting timeout errors when they try to backup a 2000 database using
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?
TIA
| |
| Dan Guzman 2005-09-28, 8:23 pm |
| Timeouts occur on the client side, not on the server, so there is no EM
setting. I hope you enjoy your trip :-)
pe this helps.
Dan Guzman
SQL Server MVP
"PKSpence" < patrick@NOSPAMpkspen
ce.com> wrote in message
news:u673qFGxFHA.3000@TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
>
> TIA
>
>
>
| |
| PKSpence 2005-09-29, 8:23 pm |
| thanks ;o(
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting. I hope you enjoy your trip :-)
>
>
> pe this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "PKSpence" < patrick@NOSPAMpkspen
ce.com> wrote in message
> news:u673qFGxFHA.3000@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|
|