Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [transaction-log]

Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.

Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.

Physically, a log is a file of updates done to the database, stored in stable storage, transaction log is not used for statements that do not modify data.

The transaction log has some important purposes:

  • data recovery if there is a system failure
  • replication
  • system maintenance
  • analysis
809 questions
7
votes
2 answers

how to reinitialize log shipping?

Here is the situation: DB on Server A had the transaction log shipping configured and uses Server B as secondary. It has been working well for a long time. However, we recently detected that one of the trn files got corrupted and Server B cannot…
Zahmatra
2
votes
1 answer

Optimal time interval for scheduling of Transaction Log Backup

I have a database which is currently of size 50 MB. The database is bound to grow by 10 to 15 MB per hour and the data is important. So, I wanted to ask what should be the optimal time interval in which a transaction log backup should be scheduled…
Jayesh
  • 23
  • 2
1
vote
1 answer

SQL log file growing exponentially

We have a SQL database on FULL back up with a client and they have NOT implemented a Log file maintenance and noticed that the log file grows exponentially, filling the 20GB they have allocated to it in a matter of days. Once they switch into…
Steve Adams
  • 11
  • 2
-1
votes
2 answers

Transaction Management

what happens to uncommitted transactions that have started before the point of checkpoint. Do they have to redone since they have been interrupted by the checkpoint period? Just want to clarify any misconceptions.
CRB
  • 1