Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
12
votes
1answer
6k views
Why Does the Transaction Log Keep Growing or Run Out of Space?
This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this:
In SQL Server -
What are some reasons the ...
4
votes
1answer
159 views
Transaction Log maintenance on Mirror database
SQL Server Version: 2008 R2 Enterprise SP2
I am trying to get a handle on our SQL Server maintenance and I came across something I think is incorrect. We have a single production instance with 3 ...
5
votes
1answer
192 views
How do I shrink the physical Transaction Log file when it's the principal in a mirror?
We setup database mirroring over the weekend, and forgot to re-enable the job that backs up the transaction logs. When I came in this morning, the transaction log had ballooned to 58GB, and was taking ...
4
votes
3answers
754 views
SQL Server virtual log size
I'm somewhat of an accidental DBA, being a developer who inherited a couple of database servers (2005 and 2008) from someone who knew little about database administration, and seemingly had even less ...
1
vote
3answers
203 views
Point in time recovery from the same database - what does it mean?
I have two questions. I have a database in full recovery mode. Lets call transaction log an LDF file for short.
SQL Server allows me to restore to point in time in the past when restoring from ...
