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

Very Low "Used Log Space Percentage" for SQL Server database transaction file

Prologue I have always read/observed that we should not shrink database file as they tend to grow back. There will be a performance penalty when DB will try to grow these files if there is not enough space already. Situation When I am executing…
UVData
  • 459
  • 2
  • 6
  • 13
0
votes
1 answer

The transaction log for database is full due to 'log_backup' / (Log)LDF file 4 times bigger than (Data)MDF

Of course I found many posts to the problem of "log_backup". But my question is now: what is the right / correct / professional way to handle this kind of problem? My database file is approx 20GB, the transaction log-file is 100 GB (4 times bigger).…
Mr.Saw
  • 1
  • 1
  • 1
0
votes
1 answer

Postgres archiving is not functioning as intended, anyone have any suggestions?

I have streaming setup between two servers master/slave and that is working fine. The archive portion is half working. It just keeps creating archive and doesn't delete older ones. Can anyone suggest a solution? I've tried the whole new base backup…
Cenzo
  • 497
  • 1
  • 4
  • 11
0
votes
3 answers

Transaction log file size carry over when performing a backup on another SQL Server

Our production server has a large .ldf file (300 gb) associated with a .mdf file. On our DEV server, we restore the DEV database using the production backup from time to time. As our DEV server should not have many transactions associated with it,…
Brian Tran
  • 115
  • 10
0
votes
1 answer

Transaction log gets full

We are on SQL Server 2016. Our recovery mode is FULL. Auto-growth is set to 4GB. Drive size is 1TB. Transaction log backup frequency is 2 hours. We have an issue with the transaction log getting full very frequently. Our data size is approximately…
Newbie
  • 713
  • 2
  • 10
  • 19
0
votes
1 answer

Performance: Create indices after or before converting from UNLOGGED to LOGGED?

I'm working on a software that initially populates tables with a lot of data (bulk mode), after which it switches to "normal" mode of operation. To make bulk mode fast, I'm starting with UNLOGGED tables with almost no indices (among other…
dpc.pw
  • 3,462
  • 1
  • 19
  • 24
0
votes
0 answers

Both tempdb and database transacton log full

We saw some substantial log growth on both tempdb and one of the user databases. Our database is in Snapshot isolation and we take transaction log backups every 15 minute. First 'TL log full error 9002' happened at 12.03, 2 minutes after the tl…
Nish
  • 21
  • 4
0
votes
1 answer

Minimizing Pre Staging DB Transaction Log growth

I have an app that loads data from a csv file into a pre-staging table and then performs some operations on it by calling some SPs before moving to staging: The data is truncated before inserts are done I am using a Simple Recovery Mode, since data…
Nimchip
  • 1,685
  • 7
  • 25
  • 50
0
votes
1 answer

SQL Server Transactional log backup is larger than full backup

Transaction log backup is 450 mb but the full backup size is 10mb. BackupType: 2 HasBulkLoggedData:0 RecoveryModel:Full BackupTypeDescription :Transaction Log auto growth setting : By 512 MB, Limited to 2097152 MB correction, the size of the mdf…
khurram shahzad
  • 9
  • 2
0
votes
1 answer

Python code causes SQL server transaction log to increase exponentially

I have a python script to execute a stored procedure to purge the tables in database. This SP further calls another SP which has delete statements for each table in database. Something like below - Python calls - Stored procedure Purge_DB Purge_DB…
garima arora
  • 21
  • 5
0
votes
0 answers

SQL Server Logs consistently get filled

I have issues with transaction logs on SQL Server 2012. I set up a job that does an automatic cleanup of logs, I used the following the plans below. Job name: Cleanup DB Logs Step 1: Do transaction log backup using Management wizard & go to "Step…
Smartiot
  • 1
  • 1
0
votes
3 answers

Restored database taking massive amount of space

I restored a database with a 1.5gb .bak file. Everything works fine except the restored database now takes 64gb of space. I've heard about shrinking databases and log files but how should I find out what is it that takes so much space and what I can…
Steve Waters
  • 3,348
  • 9
  • 54
  • 94
0
votes
1 answer

Issues in linking Hyperledger Explorer with fabricsample

Can anyone please mention the path or related details of the binary file, which is the actual ledger holding the immutable transaction log?
Parvathy.P.B
  • 11
  • 4
0
votes
2 answers

Transactions getting slower in SQL Server

We are using full recovery model in SQL Server. We have a job which merges from a staging table to the final table. The staging table is holding millions of rows. The final table is also huge with millions of rows. We are merging in batches of…
Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
0
votes
4 answers

Can a large transaction log cause cpu hikes to occur

I have a client with a very large database on Sql Server 2005. The total space allocated to the db is 15Gb with roughly 5Gb to the db and 10 Gb to the transaction log. Just recently a web application that is connecting to that db is timing out. I…
Simon Rigby
  • 1,786
  • 4
  • 17
  • 28
1 2 3
…
13 14