In my last article, I show how to create Database Mirroring for high availability. This time, I will work on Log Shipping.
The Log Shipping as the name says ships the Transactional Log from the Primary Servers to the Secondary Servers.
Read more »
Transaction log
Reading the SQL Server Transaction Log
February 9, 2015Introduction
There has always been some debate as to whether or not there are real benefits to be gained from accessing the information in the transaction log. This article will endeavor to answer that question by looking at the following:
- What is the SQL Server Transaction Log?
- What information is stored in the transaction log?
- What can be gained by accessing the information in the transaction log?
- How does the transaction log work?
- What tools are available for reading the transaction log?
- And ultimately, is this something we should be doing at all?
SQL Server Transaction Log – Part 2 – Top Reasons for Log Performance Problems
December 30, 2014In the previous article, we have examined the physical structure of the transaction log and discussed WAL algorithm. Now I will take you on a journey through the most common reasons for experiencing a log bottleneck in your systems.
Read more »
SQL Server Transaction Log – Part 1 – Log Structure and Write-Ahead Logging (WAL) Algorithm
December 18, 2014SQL Server transaction log is one of the most critical and in the same time one of the most misinterpreted part. While being neglected, it can easily become a bottleneck to our SQL Server environment. We need to have this in mind and to take care of our transaction logs in order to streamline the performance of our queries and increase log’s throughput.
Read more »
What are virtual log files in a SQL Server transaction log?
May 16, 2014What is a SQL Server transaction log file?
A SQL Server transaction log file is an integral part of every SQL Server database. Along with the data file, which has an MDF extension, the transaction log file with a LDF extension, makes a SQL Server database. Read more »
What is SQL Server log shipping?
March 16, 2014What is SQL Server log shipping?
SQL Server log shipping is a technique which involves two or more SQL Server instances and copying of a transaction log file from one SQL Server instance to another. The process of transferring the transaction log files and restoring is automated across the SQL Servers. As the process result there are two copies of the data on two separate locations Read more »
Top 10 articles on the SQL Server transaction log
February 13, 2014Understanding Logging and Recovery in SQL Server
In “Understanding Logging and Recovery in SQL Server”, Paul S. Randal has given a complete overview of the transaction log. In four sections he explains: what is logging, what is recovery, how the transaction log works, and which recovery models are available. This article can be used as a starting point in understanding fundamentals of the transaction log and the logging process Read more »
10 most important SQL Server transaction log myths
February 12, 2014
Myth: SQL transaction log truncation will make it smaller
Read more »