Exception on SqlTransaction.Rollback(), BUT it doesn't

[Guest]

Hi,

My program injects message at the same time as SQLServer is backing up
(full).
I write injecting module using Try...Catch block with SqlTransaction and
using SP.
Within Exception block I call Rollback() (it cautch timeout exception). I've
found that
it got exception on Rollback() command with InvalidOperationException
(message="This SqlTransaction has completed; it is no longer usable."). In
this
situation, sometime the message is right (inject success), but sometime it
doesn't.
How can I resolve this problem?

Thanks in advance,
Thana N.

 

[Sahil Malik [MVP]]

Replicate the SQL Server, do backups from the Replicated server.

- Sahil Malik [MVP]
Upcoming ADO.NET 2.0 book - http://tinyurl.com/9bync

 

[Guest]

I cannot do that because SQLServer is out of my control.

Thanks for your reply.