Timeout on commit during backup sqlserver

  • Thread starter Thread starter rafaelgaucho
  • Start date Start date
R

rafaelgaucho

Hello,

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

Anybody help me?
 
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
 
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.
__________________________________
 
Back
Top