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
1
vote
1 answer

Understanding delta lake reconciliation after concurrent writes

This doc explains atomicity in delta lake using trasaction logs. I am curious about the section in the image below. Specifically point number 4 It checks to see whether any new commits have been made to the table, and updates the table silently…
Ashwin
  • 12,691
  • 31
  • 118
  • 190
1
vote
1 answer

Finding LSN from a given time in SQL Server when CDC is disabled

How do we find out a LSN given a timestamp given that CDC is disabled ? I know that in case when CDC is enabled it can be done via fn_cdc_map_time_to_lsn stored procedure but is there a way to get to the same info when CDC is not enabled.
Ravi Jain
  • 86
  • 1
  • 4
1
vote
1 answer

How to convert 8 byte datetime from fn_dblog() details in [Log Content 0] into a C# DateTime object?

I've deleted a row of data that was inserted recently. Rather than restore and roll forward a second copy of this huge DB to retrieve the inserted data, I'm trying to use the fn_dblog() "undocumented" system function to retrieve it. Using a…
Brian B
  • 1,509
  • 3
  • 20
  • 29
1
vote
1 answer

Transaction Log Backup fails with "Exclusive access could not be obtained because the database is in use"

I am attempting a Log Shipping failover test and the step which is intended to put the database into restoring mode is failing with the error "Exclusive access could not be obtained because the database is in use". The action was carried out through…
Marathon_Nick
  • 11
  • 1
1
vote
1 answer

How to shrink log file in SQL Server after unknown period of not being backed up?

I recently took over management of a database that has been in use for 2-3 years, and it had no transaction log maintenance plan in place. The DB file is 8 GB, but the transaction log file is a whopping 54 GB. I started backing up the log file, and…
Thomas Glosser
  • 13
  • 2
1
vote
1 answer

Transaction Log in Aerospilke

What I have? A lot of different microservices managing by different teams. All microservices persist data in Aerospike database. What I want to achieve? I'm building new microservice that relies on data handled by another services. I want to listen…
Serge Harnyk
  • 1,279
  • 10
  • 19
1
vote
1 answer

How do i see "INSERT" Transaction log in Microsoft SQL Server?

I am trying to find out how does my script from another system insert into the database as it takes 30 minutes, way too long. I want to see how every record in which period is being inserted. The database server has multiple database and each…
B.Dick
  • 305
  • 2
  • 11
1
vote
0 answers

SSIS active log transaction issue

I have 13 different table to import to different server and each table there are about 30 millions records and including one which has 90 million records. I tried one load for one table in SSIS for 50 million of data and this was completed in an…
Dijal
  • 47
  • 5
1
vote
0 answers

In terms of transaction log, what is the difference between SQL Bulk Insert and SQL Insert after changing the Recovery model to Bulk Logged?

In terms of transaction log, What is the difference between 'SQL Bulk Insert' and 'SQL Insert after changing the Recovery model to Bulk Logged'?
variable
  • 8,262
  • 9
  • 95
  • 215
1
vote
1 answer

nHibernate transaction logging

Our application uses nHibernate, and there is a requirement to log all changes to a certain table. I don't need to log the entire queries generated by the ORM, just the data and the date. For example, let's say I have an entity called…
dzenesiz
  • 1,388
  • 4
  • 27
  • 58
1
vote
1 answer

Is there are a way to check the last time a shrink operation was done on a SQL Server 2000 transaction log

I've got a database running on a clients SQL Server 2000 box where the transaction log file is only 1MB in size. This seems very perculiar. I can't find any Database Maintenance Plan or individual SQL agent job that is explicitly shrinking it so I'm…
Peter
  • 797
  • 11
  • 35
1
vote
1 answer

What's the relationship between checksum and full page image?

Recently, I learned some about PostgreSQL data checksum and feel confused about the relationship between checksum and full page image. As the following comment said at: If we need to protect hint bit updates from torn writes, WAL-log a full page…
inferno
  • 684
  • 6
  • 21
1
vote
0 answers

Transaction log filling the drive if mirroring fails

I am having two mirrored SQL Server 2016 machines with mirroring set up. This is supposed to be hot-standby scheme. HDD size is 1TB, and database size is around 600GB (just one DB). This is 90 days worth of archived data, everything older than 90…
D.T
  • 11
  • 2
1
vote
1 answer

AWS RDS Postgresql Transaction logs keep going when there is no data change?

You can have see these problem https://www.reddit.com/r/aws/comments/7snob5/postgresql_transaction_logs_fill_up_storage_till/ https://dba.stackexchange.com/questions/173267/aws-rds-postgres-logical-replication?rq=1 And my problem may be a little…
jiamo
  • 1,406
  • 1
  • 17
  • 29
1
vote
2 answers

Transaction Log remains 60GB size, even after changing to Full Recovery

Just started with a company and noticed that their database was set to Simple Recovery. I talked to the owner and suggested to convert it to Full Recovery, explained to him the benefit of using a transaction log and backed up every hour. After he…
RSPerez
  • 11
  • 4
1 2 3
…
13 14