Click to See Complete Forum and Search --> : TimeOut Expired Error on Backup


dastak4
September 25th, 2008, 02:50 AM
hi,

i m using SQL Server 2000. when i send query for Backup through VB6 it is generated error "Timeout Expired".
it takes approx. 2 mints to take backup even in Enterprise Manager.
plz somebody help me that what is it and whats its solution ?

thanks

Alsvha
September 29th, 2008, 03:28 AM
You properly do not have set a new timeout on your connection which usually is about 30 seconds or so.
I do not know VB6, but look for a SetCommandTimeout or similar on the connection and then enter a new value on that property.