-
long-running transactions and log dumps?
Hello:
I am reviewing our backup strategy.
The application, running on mssql 6.5, sp4, involves long-running transaction intermittently during a given month but particularly so at month-end as this is a financial application written in Powerbuilder.
I have been thinking of including the dumping of the transaction log several times a day but I am concerned about the effect of a long-running transaction when the log has to be dumped. The result will probably hang the transaction or the dump; neither being the desired result. It's difficult to determine when the transaction willocur most times.
1) Has any one experienced something like this with long_running transactions and log dumps?
2) Any other thoughts on this?
Thanks.
David Spaisman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|