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

SQL Server 2008 Transaction Log: Date/Time

Need to roll back a delete query, so I'm sifting through the transaction logs without really knowing what the meanings of most of the headers are. TO ME, it looks like Current LSN, and possibly Transaction ID MIGHT be date or time but in a…
109221793
  • 16,477
  • 38
  • 108
  • 160
0
votes
1 answer

SQL transaction log shipping after differential backup

I'm facing a scenario: Full backup of production database is created Full backup is restored to DR database A differential backup of production database is created, BUT accidentally deleted Start transaction log backup on production database The…
Brian Pham
  • 551
  • 9
  • 23
0
votes
1 answer

DB2 ZOS Mainframe- Archive Logs Disable

I'm working in DB2 ZOS Version 10, I have been working under data masking project. For this project I have been executing over 100k DDL statements (delete, update,insert) . So I need to do disable the transaction logs before the whole SCRAMBLE…
Vivek Harry
  • 419
  • 3
  • 11
  • 25
0
votes
1 answer

neo4j transaction log delete

Storage on my machine is almost full. I need to delete neo4j transaction logs to make some space on the machine. But for safe deletion of transaction logs, it is recommended to stop neo4j first and then delete. But due to insufficient space neo4j is…
Jagmohan Singh
  • 93
  • 7
0
votes
0 answers

Actionlogging with Node

I am quite sure that I am not the first person on the planet trying to implement the following, but I am sure that I am not able to find a good guide how to do it. Our node backend is setup quite like a MVC to say so. View = Express Server offering…
mambax
  • 1,079
  • 8
  • 17
0
votes
1 answer

Why will my SQL Transaction log file not auto-grow?

The Issue I've been running a particularly large query, generating millions of records to be inserted into a table. Each time I run the query I get an error reporting that the transaction log file is full. I've managed to get a test query to run…
MKC
  • 64
  • 6
0
votes
1 answer

NUM_LOG_SPAN usage on a DB2 database (10.1)

Is there any way to see how many transaction logs a process (agent_id) currently spans? Or list the transaction logs it's currently using/spanning? I.e. is it possible to check if NUM_LOG_SPAN is about to be reached? We've had an issue recently…
Ross Armstrong
  • 11
  • 6
0
votes
1 answer

SQL Server Used Transaction Log Space Not Decreasing After Long UPDATE Finishes

In SQL Server, I have a table (dbo.MYTABLE) containing 12 million rows and 5.6 GB storage. I need to update a varchar(150) field for each record. I perform the UPDATE operation in WHILE loop, updating 50K rows in each iteration. Transaction log…
Ahmet Altun
  • 3,910
  • 9
  • 39
  • 64
0
votes
0 answers

SQL Server: How to retrieve last 12 hours of logs using fn_dblog?

Having accidentally nullified a column in MS SQL 2012, I'm looking at how to use fn_dblog for the first time. I had previously backed up the table, and deleted it this morning. I am using full recovery mode (code below for anyone in the future who…
Zach Smith
  • 8,458
  • 13
  • 59
  • 133
0
votes
0 answers

Minimize Logging without Setting Bulk Logged

What is the best way to minimize an SQL transaction log without setting the database to simple recovery mode bulk logged? I'm using Amazon, and the database does not allow bulk logging. From what I've researched, the best way would be removing…
jle
  • 269
  • 8
  • 25
0
votes
2 answers

Is transaction log shipping affected by long running redgate script

I have a long running redgate script that is applying a bunch of schema type changes to a database. It is going to take 3 hours to run. This script will be run on a production database that has mirroring and transaction log shipping in place. My…
Jen
  • 1,964
  • 9
  • 33
  • 59
0
votes
0 answers

How can I solve whatever is causing SQL Server to throw "The transaction log for database 'tempdb' is full due to 'NOTHING'"?

SQL Server complains that it is full of nothing, which is, I guess, better than being full of some other things. This question has some very interesting answers, especially the one by Steven. However, after running the script he provided, rather…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
0 answers

how to determine how big the current uncommitted sql transaction will be

I found a blog a while back that had the sql to determine how expensive updating a clustered index was. Sql will do a delete and a insert. It did something like this: begin trans update mytable set myclusteredindexColumn = 'abc' where…
randy
  • 253
  • 4
  • 17
0
votes
1 answer

Is the log file becomes deleted, if I change the backup type?

I need to backup the transaction log file of the database but backup type of it is "simple". I will change it as "full" but I cannot be sure about log file will be deleted or not after this operation. Can anyone help me at this point? Thanks a lot.
mrciga
  • 47
  • 8
0
votes
3 answers

Update query on millions of rows fills the transaction log

I need to update millions of rows as part of my next release, but doing so fills the transaction log and fails. I have a few ideas but I'm not a SQL expert so I'm sure there will be gotchas that I'm not aware of. Pertinent points: I need to hand a…
Phil Gan
  • 2,813
  • 2
  • 29
  • 38
1 2 3
…
13 14