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
4
votes
3 answers

Sql Server Transaction Log Reader

Is it possible to open a sql server transaction log file with some type of a stream reader object? I've tried in C# a variety of ways but the database appears to be opening the .ldf file with an explicit lock and even though I only want to read the…
G D
  • 41
  • 1
  • 4
3
votes
0 answers

Get primary key(s) from fn_dblog update transaction

I need to get the primary key(s) of an updated row from SQL Server transaction logs obtained via fn_dblog. As I can see, when the Operation is either LOP_MODIFY_ROW or LOP_MODIFY_COLUMNS, the [RowLog Contents 2] has the primary key. But it also has…
Babu James
  • 2,740
  • 4
  • 33
  • 50
3
votes
1 answer

Why am I seeing Sql Error 1105 in my Azure Sql Database?

I have a database hosted in Azure Sql and am seeing a critical 1105 error. This error occurs whenever my transaction needs more space than is available in the transaction log. According to the documentation, whenever this occurs, all active…
Matt Mangold
  • 710
  • 1
  • 6
  • 10
3
votes
1 answer

Don't quite understand SQL Server transaction logs

I've read up on SQL Server transaction logs, but still not entirely comfortable with how to use/manage them. I get that they are important for things like transaction rollbacks, mirroring, replication and log shipping etc. To me, they still seem…
kenwarner
  • 28,650
  • 28
  • 130
  • 173
3
votes
1 answer

Microsoft SQL Server 2008 Log analysis

I have a SQL Server 2008 database with a transaction log that grows very rapidly each day. Is anyone aware of any tool that could be used to analyze in greater detail what transactions that make up the greater part of the log bulk? This so I know…
Marcus Johansson
  • 31
  • 2
3
votes
3 answers

Finding what is writing to the Transaction Log in SQL Server?

Is there a way to see what is writing to the transaction log? I have a log file that has grown 15 Gigs in the last 20 minutes. Is there a way for me to track down what is causing this?
Abe Miessler
  • 82,532
  • 99
  • 305
  • 486
3
votes
2 answers

Log Chains and SQL Server Transaction Log - sanity check

I'm helping with a rather ad-hoc disaster recovery, and we've restored a database backup from a few weeks ago and then restored transactions from a transaction log backup. We did this using SQL Server Management Studio - right click on database,…
codeulike
  • 22,514
  • 29
  • 120
  • 167
3
votes
1 answer

zookeeper transactional logs grow to be very big

The zookeeper transactional logs grow to be very big (Serveral Gigabytes ! ) and there is always one or -at the maximum- two transactional log files in each machine of the cluster knowing that there could be multiple snapshots ! .. Introducing…
user3580691
  • 88
  • 8
3
votes
1 answer

transaction logging in neo4j community 3.0

I recently installed the community version of neo4j on a linux server. Now I'm trying to verify queries that are running remotely but I can't seem to find any sort of transaction log. Most parameters I find are referencing 2.3 configurations (which…
Matt Viss
  • 53
  • 5
3
votes
3 answers

How to find out current transaction log size in DB2?

How to find out the current transaction log size? Is it possible to do e.g. by querying some system tables with SQL? It would also be interesting to find out the maximum size for the transaction log. Is the only option to look it up from the file…
Juha Syrjälä
  • 33,425
  • 31
  • 131
  • 183
3
votes
0 answers

Backup Zookeeper data on active server

I am trying to configure production-ready Zookeeper data backup. As I learned from different sources, Zookeeper snapshot file is not enough to guarantee a return to a previous state. In fact, the snapshot file may not even represent the state of the…
Nikita Mendelbaum
  • 659
  • 5
  • 16
3
votes
4 answers

SQL Server 2008 log file size is large and growing quickly

Most of the time users will hit the database to read news. There are very few number of queries executed under transactions. 95% of the database hits would be for read-only purposes. My database log files size is growing 1 GB per day. Even if I…
kiran
  • 31
  • 1
  • 1
  • 2
3
votes
8 answers

Microsoft SQL Server - What does it mean that a Transaction Log is Full?

What does it mean that a Transaction Log is Full? I have it the file set to grow 20% when needed. I have 4GBs left on the drive. How do I solve this issue permanently? Running these commands solves the issue temporarily: DBCC…
BuddyJoe
  • 69,735
  • 114
  • 291
  • 466
3
votes
1 answer

SQL Server - What's in that log backup?

So I noticed that one of my log backups is about 1000x larger than normal. I'd like to see what is in there. Is there something I can use to read it? Thanks!
anon
  • 33
  • 2
3
votes
1 answer

SQL Server 2005 - How to find out what transaction log files have been restored

How can you find out what transaction log backup files have been restored using SQL in SQL Server 2005?
GordyII
  • 7,067
  • 16
  • 51
  • 69
1 2
3
…
13 14