|
- Sql server - log is full due to ACTIVE_TRANSACTION
Sql server - log is full due to ACTIVE_TRANSACTION [duplicate] Asked 11 years, 1 month ago Modified 8 years, 1 month ago Viewed 366k times
- How to rollback or commit a transaction in SQL Server
The good news is a transaction in SQL Server can span multiple batches (each exec is treated as a separate batch ) You can wrap your EXEC statements in a BEGIN TRANSACTION and COMMIT but you'll need to go a step further and rollback if any errors occur
- The transaction log for database tempdb is full due to ACTIVE . . .
@GiulioCaccin Thank you for the suggestion, but I ran a query on the transaction logs and the log space used for tempdb is only at 31% The other inquiry you referred me to also doesn't help me to understand why the temp objects I create refuse to be dropped or created Unless there's something that I am missing from your suggestion
- The transaction log for the database is full - Stack Overflow
I 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
- sql server - How to use SqlTransaction in C# - Stack Overflow
There is an Update query in progress, the Transaction is started at a higher level on the connection In order to ensure that all server data is in a valid state for the Update, I need to do a couple reads
- c# - How to use TransactionScope properly? - Stack Overflow
The 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
- The transaction log for database is full due to LOG_BACKUP in a . . .
The transaction log for database 'db_name' is full due to 'LOG_BACKUP' I searched around and found a lot of related answers like this and this or this but the problem is they suggest running a query on the database
- What is the difference between a query and transaction in SQL?
A simple explanation would be like this Query is a single instruction like SELECT, UPDATE, DELETE etc and transaction is group of query to perform particular task in case of money transaction operation, there are multiple tasks we need to perform like select account, verify balance, debit balance and credit balance so this 4 queries can be together an form a txn
|
|
|