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...
Getting "Lock wait timeout exceeded; try restarting transaction" …
Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction Asked 14 years, 6 months ago Modified 7 months ago Viewed 1.2m times
ERROR: cannot execute CREATE TABLE in a read-only transaction
Jul 4, 2015 · I was having getting cannot execute CREATE TABLE in a read-only transaction, cannot execute DELETE TABLE in a read-only transaction and others. They all followed a …
Sql server - log is full due to ACTIVE_TRANSACTION
May 23, 2014 · Sql server - log is full due to ACTIVE_TRANSACTION [duplicate] Asked 11 years, 5 months ago Modified 8 years, 6 months ago Viewed 371k times
How to see query history in SQL Server Management Studio
Check out this thread for more details here SQL Server Transaction Log Explorer/Analyzer SQL Server profiler – best suited if you just want to start auditing and you are not interested in what …
java - Could not commit JPA transaction: Transaction marked as ...
Could not commit JPA transaction: Transaction marked as rollbackOnly This exception occurs when you invoke nested methods/services also marked as @Transactional.
How do I decrease the size of my sql server log file?
6 Ensure the database's backup mode is set to Simple (see here for an overview of the different modes). This will avoid SQL Server waiting for a transaction log backup before reusing space. …
java - javax.transaction.Transactional vs org.springframework ...
266 I don't understand what is the actual difference between annotations javax.transaction.Transactional and …
Why can't I shrink a transaction log file, even after backup?
Apr 23, 2009 · I have a database that has a 28gig transaction log file. Recovery mode is simple. I just took a full backup of the database, and then ran both: backup log dbmcms with …
Is there a way to list open transactions on SQL Server 2000 …
Does anyone know of any way to list open transactions on SQL Server 2000 database? I am aware that I can query the view sys.dm_tran_session_transactions on SQL 2005 (and later) …