Stack Overflow
Stack Overflow

Questions tagged [transaction-log]

transaction log is a log file of all actions performed on a database. It helps keep consistency and recover from unexpected failures.

The Transaction Log is a log file that keeps an audit trail of all actions performed on a database. This allows the database system to recover from unexpected shutdowns like power failures. Usually, the system will roll back changes made by uncommitted transactions and re-apply any committed transaction that did not make it to the database. This is done to keep ensure the atomicity and durability of transactions.

The transaction log can also be used to recover accidentally changed or deleted data.

197 questions
0
votes
2 answers

t-sql transaction log ballooning. Finding cause due to SP's

We have an problem with our transaction log (2008 R2) growing very quickly (despite full backups). In SQL profiler, I ran a trace capturing all Insert, Delete and Update statements with rowcount and they were all very low. Many of the apps running…
mark1234
  • 1,110
  • 2
  • 24
  • 41
0
votes
0 answers

Transaction log clearance of a DB in SQL Server 2012 when DB is part of always on

We have a DB which is part of ALWAYS ON. We want to clear the transaction logs for that DB because that is just a production server where we replicate data from one of our other production server 4 times a day. As we do snapshot replication of 4 GB…
Love Gupta
  • 975
  • 2
  • 16
  • 31
0
votes
2 answers

sql server update affects 0 records but fills transaction log

I have a SQL statement that updates records in a table if the query returns any records. The query only returns records if they need to be updated. When I run the select on the query I get no records so when the update runs there should be no…
RUEMACHINE
  • 381
  • 2
  • 9
  • 23
0
votes
1 answer

How to test transaction log shipping

We are a small division of a larger company and we are required to keep a server at the corporate office as a disaster recovery server. I want to use SQL's (2005) transaction log shipping feature to keep the offsite server up-to-date. The problem…
VinPepe
  • 561
  • 1
  • 4
  • 9
0
votes
2 answers

LDF file continues to grow very large during transaction phase - SQL Server 2005

We have a 6 step where we copy tables from one database to another. Each step is executing a stored procedure. Remove tables from destination database Create tables in destination database Shrink database log before copy Copy tables from source to…
that_developer
  • 319
  • 2
  • 9
0
votes
3 answers

SQL Server full log issue -- how to update the database?

I am working with SQL Server 2000, and trying to change the data type of a field from varchar to nvarchar, so that it can handle international characters. However, there is already a lot of data in that table, and when I try to save the change, I…
twpc
  • 709
  • 3
  • 16
  • 26
0
votes
2 answers

com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction

My jsp site as well as asp site started throwing error messages when the transaction log of the Microsoft database got full. So I went in and shrunk the log file and the asp site started working just fine, bu the jsp site is still throwing error…
Ratan
  • 863
  • 5
  • 12
  • 28
0
votes
2 answers

how to catch log suspend scenario in Sybase?

There are few shell scripts that use the isql to execute some sql statements on a Sybase database server. I see several Log Suspend messages in the logs and the problem is that the shell script exits with success. The transaction log in database…
mtk
  • 13,221
  • 16
  • 72
  • 112
0
votes
1 answer

Why is my SQL Server 2005 transaction log not growing/updating?

I have SQL Server 2005 Database where the transaction log has not updated in a week. The transaction log has recently been truncated due to a situation that used up all available disk space. I have a test database on the same server which is growing…
Dan H.
0
votes
1 answer

Database Backup, drop transaction logs, shrink, drop nonclustered indexs, rebuild tables Fill factor 100%, compress

Let me start by saying I am a developer and I am just taking database backups for bug testing/fixing. I want to get the size of the backups I am taking down because at the moment it would be faster getting the backups posted to me than transfering…
user802599
  • 787
  • 2
  • 12
  • 35
0
votes
0 answers

Monitor statements in SQL Server 2005 using a query

I need to write a query to get the statements executed by the user in a particular database since the last restart. First of all, I extract all the transactions from ::fn_dblog(NULL,NULL), which returns the transaction log. After this, I tried to…
The guy at the corner
  • 1
0
votes
1 answer

SQL Server: manipulating huge amount of data in single transaction

I have a really huge table on SQL Server with ~1 billion rows, we need to migrate data from this table to another with such a simple code: SET XACT_ABORT ON BEGIN TRAN INSERT INTO TargetTable SELECT Col1, Col2, ... ColN FROM HugeTable ht …
tartakynov
  • 2,768
  • 3
  • 26
  • 23
-1
votes
2 answers

SQL Server Clear transaction log

I have a database that is in Full Recovery Mode that I restored from a backup file Now I want to clear/truncate the transaction log file. How I can do this. Step 1 I tried to backup the transaction log using BACKUP LOG [test] TO DISK but I get…
dana
  • 3
  • 2
-1
votes
1 answer

SQL Server: What exactly is the backup_finish_date in master.sys.databases

When querying for the last backup_finish_date with the following query (from SQL Server: how to query when the last transaction log backup has been taken?): SELECT d.name, d.recovery_model_desc, MAX(b.backup_finish_date) AS…
Zach Smith
  • 8,458
  • 13
  • 59
  • 133
-1
votes
1 answer

Transaction log File Backup

I am using Sql server 2008 with full recovery model , My Transaction log file size is (172 M), i tried to backup the log file, the backup process completed successfully, but its only took (1000 KB)
mimiKh
  • 17
  • 1
  • 3
1 2 3
…
13
14