Timeout on commit during backup sqlserver

4 Nov 2005 11:26 AM

rafaelgaucho@gmail.com

Hello,

During sqlserver2000 backup, I try to insert a record with transcation,
but on .commit() are throw timeout expired exception.

Anybody help me?

4 Nov 2005 4:25 PM

Andrew Robinson

Depending on the type of backup, your database maybe locked. Especially if
your are doing a DBCC (Database consistancy check) before and / or after the
backup. This is an option with Veritas and I would guess other backup
software.

-Andrew

<rafaelgau***@gmail.com> wrote in message
Show quote

news:1131103584.067011.226230@g14g2000cwa.googlegroups.com...
> Hello,
>
> During sqlserver2000 backup, I try to insert a record with transcation,
> but on .commit() are throw timeout expired exception.
>
> Anybody help me?
>

4 Nov 2005 4:34 PM

William (Bill) Vaughn

Increase the CommandTimeout?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

<rafaelgau***@gmail.com> wrote in message

Show quote

news:1131103584.067011.226230@g14g2000cwa.googlegroups.com...
> Hello,
>
> During sqlserver2000 backup, I try to insert a record with transcation,
> but on .commit() are throw timeout expired exception.
>
> Anybody help me?
>