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

SQL server 2000 how to find transaction history for a table/row

How do you find the modification history for a certain table / row in SQL server 2000? Thanks.
Stan
  • 37,207
  • 50
  • 124
  • 185
0
votes
2 answers

Unable to delete records as the transaction log file is full

My disk is running out of space and as a result I decided to free some space by deleting old data. I tried to delete 100,000 by 100,000 as there are 240 million records to be deleted. But I am unable to delete them at once and shrinking the database…
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
0
votes
1 answer

Database mirroring out of sync after Transcriptional log backup

In SQL server Database mirroring, I need to bring down the Mirror server for maintenance for 2 hours. However If I have a transaction log backup on the Primary database running every 15 mins, Will database mirroring still work, when the mirror…
waazi
  • 25
  • 1
  • 6
0
votes
0 answers

SQL Server database log file growing large with no usage

I have a log file on a SQL Server database that grows to 70 times its regular size outside of regular business hours. During regular business hours the transaction log for this DB will safely sit (with no growth operations) around 1Gb but every…
rin-tin-tin
  • 21
  • 7
0
votes
2 answers

SQL Server log_reuse_wait_desc LOG_BACKUP, Transaction log full, does not become smaller after log backup

I did the backup of database which is small 2MB. I have transaction log file (LDF file) of 15GB! My database is in Full recovery mode. First I tried to do the backup of transaction log but it failed because of the space on the server. Then I…
Veljko
  • 1,708
  • 12
  • 40
  • 80
0
votes
0 answers

Why SqlServer needs a big transaction log file

I've been working in a SQLServer 2012 database for several years at work and I have always wondered about a strange thing I have observed with transaction logs. I 've been searching on Internet and StackOverflow for an explanation without success. I…
dgisbert
  • 81
  • 1
  • 5
0
votes
0 answers

SQL Server Transaction backups - should overwrite file?

Heyo, This question is quite simple. I have a T-SQL backup script run by SQL Server Agent. A differential backup is taken every hour, bar once per day, when a full is taken. After either differential or full, a transaction log is backed up. In…
Whoop5
  • 47
  • 2
  • 12
0
votes
0 answers

High VLF count even with frequent SQL Log Backups

One of our servers is an SQL Server 2008 R2 database (full recovery) of less than 100GB in size that is backed up daily with transaction log backups taken every 15 minutes. The Log file growth is set to 500MB. But no matter what I do, I cannot get…
user3064548
  • 21
  • 2
0
votes
1 answer

SQL Server 2012 is not using transaction log

I have a SQL Server 2012 Express. Now, I have seen, that it is not using the log-file anymore. The size of the log file is always 2MB and the changedate is in the past. The database is in high use so I am wondering me, why the transaction log is not…
BennoDual
  • 5,865
  • 15
  • 67
  • 153
0
votes
1 answer

Log Drive Full Due to ReportServer Database Growing

I have a report server log file that is 100 million kb. The report server was set to full recovery with no transaction log backup configure. I added a Tlog backup which should truncate the file over time. But the sql logs drive is completely…
user3423484
  • 1
  • 1
0
votes
2 answers

SQL 2005 Log File Initial Size

I've a question regarding the SQL Log File size and what it should be set at after a log file backup. I know it depends on a lot of factors, and that there is no right or wrong amount (relatively speaking, as I'd not start the log at the 1 mb as is…
ctmcklowe96
  • 97
  • 3
  • 11
0
votes
1 answer

Disk full because of transaction log caused by expensive query

I have a problem with a query that could look simple but it is causing me a lot of problems here in my development environment. What I'm trying to do is to change the articleID by a new article ID that I have in a new table. +-----------------+ | …
Desdoyer
  • 82
  • 1
  • 7
0
votes
1 answer

Copying restoring databases in SQL Server 2008/2012

I've got two SQL Servers, one of these servers (Server A) is backing up transaction logs on some database and uploading them to the other (Server B). Unfortunately I have no access to Server A, I simply have to trust that it is doing its job of…
user3074410
  • 1
  • 1
0
votes
1 answer

How does SSMS get the transaction log usage?

When you right-click on database, Reports...Disk Usage, I get a report. Because I have limited permissions, I only get the top portion, which shows "Transaction Log Space Usage" - that number alone could be useful to me. However, later I get error…
Cade Roux
  • 88,164
  • 40
  • 182
  • 265
0
votes
0 answers

How does the database write log atomically?

In section 9.3.2 of "Principles of Computer System Design" LOG is a procedure to write a log atomically (with all-or-nothing semantic) to disk to implement write-ahead-log protocol. But the book does not discuss the details about implementation of…
spockwang
  • 897
  • 1
  • 6
  • 15
1 2 3
…
13 14