http://www.bing.com:80/search?q=Transaction+Backup+SQL+ServerSearch resultshttp://www.bing.com:80/s/a/rsslogo.gifhttp://www.bing.com:80/search?q=Transaction+Backup+SQL+ServerCopyright © 2026 Microsoft. All rights reserved. These XML results may not be used, reproduced or transmitted in any manner or for any purpose other than rendering Bing results within an RSS aggregator for your personal, non-commercial use. Any other use of these results requires express written permission from Microsoft Corporation. By accessing this web page or using these results in any manner whatsoever, you agree to be bound by the foregoing restrictions.https://stackoverflow.com/questions/21930156/transaction-count-after-execute-indicates-a-mismatching-number-of-begin-and-commExec USPStoredProcName I get the following error: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. I have read the answers in other such questions and am unable to find where exactly the commit count is getting messed up.Wed, 15 Apr 2026 03:57:00 GMThttps://stackoverflow.com/questions/974596/what-is-a-database-transactionA transaction is a unit of work that you want to treat as "a whole." It has to either happen in full or not at all. A classical example is transferring money from one bank account to another. To do that you have first to withdraw the amount from the source account, and then deposit it to the destination account. The operation has to succeed in full. If you stop halfway, the money will be lost ...Thu, 16 Apr 2026 12:24:00 GMThttps://stackoverflow.com/questions/19302196/transaction-marked-as-rollback-only-how-do-i-find-the-causeParticipating transaction failed - marking existing transaction as rollback-only So I just stepped through my code to see where this line is generated and found that there is a catch block which did not throw anything.Sun, 12 Apr 2026 22:23:00 GMThttps://stackoverflow.com/questions/17674973/the-transaction-log-for-the-database-is-fullI have a long running process that holds open a transaction for the full duration. I have no control over the way this is executed. Because a transaction is held open for the full duration, whe...Thu, 16 Apr 2026 15:30:00 GMThttps://stackoverflow.com/questions/1171749/what-does-a-transaction-around-a-single-statement-doBEGIN TRANSACTION / COMMIT "extends" this locking functionality to the work done by multiple statements, but it adds nothing to single statements. However, the database transaction log is always written to when a database is modified (insert, update, delete). This is not an option, a fact that tends to irritate people.Thu, 16 Apr 2026 02:30:00 GMThttps://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-immysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction I'm not using a transaction, so why would I be getting this error? I even tried restarting my MySQL server and it didn't help. The table has 406,733 rows.Sun, 12 Apr 2026 19:10:00 GMThttps://stackoverflow.com/questions/56628/how-do-you-clear-the-sql-server-transaction-logThe transaction log contains a lot of useful data that can be read using a third-party transaction log reader (it can be read manually but with extreme effort though). The transaction log is also a must when it comes to point in time recovery, so don’t just throw it away, but make sure you back it up beforehand.Tue, 07 Apr 2026 21:03:00 GMThttps://stackoverflow.com/questions/7488149/sql-transaction-error-the-current-transaction-cannot-be-committed-and-cannot-suI'm having a similar issue to The current transaction cannot be committed and cannot support operations that write to the log file, but I have a follow-up question. The answer there references Usi...Thu, 16 Apr 2026 23:08:00 GMThttps://stackoverflow.com/questions/14160788/how-to-use-transactionscope-properlyThe code within the methods you call need to be transaction aware and enlist in the active transaction. This means creating or using classes which are resource managers (see Implement Your Own Resource Manager. You do this by implementing IEnlistmentNotification and enlisting in the transaction. When the transaction is completed, the transaction manager will call methods as defined on that ...Mon, 13 Apr 2026 17:28:00 GMThttps://stackoverflow.com/questions/8645694/row-was-updated-or-deleted-by-another-transaction-or-unsaved-value-mapping-wasoptimistic locking consists in detecting that another transaction has updated/deleted the same row, and throwing the exception you're getting in this case. If you have a version field, you're already using optimistic locking, and this is what throws the exception. Pessimistic locking will make your application slow and subject to deadlocks.Thu, 16 Apr 2026 19:27:00 GMT