transaction log Archives - {coding}Sight https://codingsight.com/tag/transaction-log/ Blog for SQL Server DBAs and Developers Mon, 06 Nov 2023 09:06:25 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png transaction log Archives - {coding}Sight https://codingsight.com/tag/transaction-log/ 32 32 SQL Server Transactional Replication Configuration https://codingsight.com/transactional-replication-sql-server-configuration-tutorial/ Wed, 30 Jun 2021 11:12:53 +0000 http://codingsight.com/?p=14957 Transactional Replication in SQL Server is one of the most commonly used Replication techniques to copy or distribute data across multiple destinations. In previous articles, we discussed SQL Server Replication and how Replication internally works. Now our goal is to see how to Configure Transactional Replication in SQL Server using the Backup approach and how …

The post SQL Server Transactional Replication Configuration appeared first on {coding}Sight.

]]> SQL Server Transactional Replication Internals https://codingsight.com/sql-server-transactional-replication-internals/ Mon, 17 May 2021 13:06:26 +0000 http://codingsight.com/?p=13829 SQL Server Transactional Replication is one of the most common Replication techniques used to share, copy, or distribute data to multiple destinations. In this article, we will discuss Replication, various Replication Types, and pay special attention to the Transactional Replication work. Table of contents What is SQL Transactional Replication? SQL Server Replication Architecture & Terminologies …

The post SQL Server Transactional Replication Internals appeared first on {coding}Sight.

]]> Basics of SQL Server Transaction Log https://codingsight.com/basics-of-sql-server-transaction-log/ Wed, 31 Mar 2021 16:26:20 +0000 http://codingsight.com/?p=12604 What is a Transaction Log? There is a requirement in relational database systems that transactions must be durable. This is “D” in the ACID properties of transactions. The system must ensure that if a sudden crash happens, the transaction can be replayed. SQL Server fulfills this requirement by capturing all transactions in a physical file …

The post Basics of SQL Server Transaction Log appeared first on {coding}Sight.

]]> Configure SQL Server Log Shipping https://codingsight.com/configure-sql-server-log-shipping/ Thu, 22 Oct 2020 11:22:13 +0000 https://codingsight.com/?p=10369 This article explains the step by step deployment process of the SQL Server Log shipping. It is the database-level disaster recovery solution that is easy to set up and maintain. The log shipping involves three steps: Generate the log backup on the primary database. Copy the backup to the network location or the specific directory …

The post Configure SQL Server Log Shipping appeared first on {coding}Sight.

]]> Creating Maintenance Plans in SQL Server https://codingsight.com/creating-maintenance-plans-in-sql-server/ Wed, 08 Jul 2020 08:36:58 +0000 https://codingsight.com/?p=9393 Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the databases that are hosted therein are kept in shape. Maintenance Plans offer a database administrator an opportunity to configure key tasks like indexing, statistics updates, backups, log cleanups, and others. In …

The post Creating Maintenance Plans in SQL Server appeared first on {coding}Sight.

]]> Using Trace Flag 3226 to Suppress Log Backup Logging https://codingsight.com/using-trace-flag-3226-to-suppress-log-backup-logging/ Thu, 18 Apr 2019 23:21:10 +0000 https://codingsight.com/?p=6606 Introduction Every backup operation in SQL Server is written to the SQL Server Error log. This includes Transaction Log Backups even when they occur as part of a Transaction Log Shipping Configuration. Sometimes logging the entire Log Backup can be a nuisance in the SQL Server Error Log and needs to be managed. Trace Flag …

The post Using Trace Flag 3226 to Suppress Log Backup Logging appeared first on {coding}Sight.

]]> Importance of transaction log in SQL Server https://codingsight.com/importance-of-transaction-log-in-sql-server/ Tue, 13 Nov 2018 17:00:25 +0000 https://codingsight.com/?p=5567 Transaction logs are a vital and important component of database architecture. In this article, we’ll discuss SQL Server transaction logs, importance, and their role in the database migration. Introduction Let’s talk about different options for taking SQL Server backups. SQL Server supports three different types of Backups. 1. Full 2. Differential 3. Transaction-log Before jumping …

The post Importance of transaction log in SQL Server appeared first on {coding}Sight.

]]> Fixing Data Loss Using Log Shipping with Delayed Recovery https://codingsight.com/fixing-data-loss-using-log-shipping-with-delayed-recovery/ Tue, 07 Aug 2018 13:44:14 +0000 http://codingsight.com/?p=4919 Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to maintain a copy of the live database in the Disaster Recovery Site. The technology depends on three key jobs: the Backup Job, the Copy Job, and the Restore Job. While the Backup job runs on the Primary Server, the Copy and …

The post Fixing Data Loss Using Log Shipping with Delayed Recovery appeared first on {coding}Sight.

]]> SQL Server Database Backup Encryption https://codingsight.com/sql-server-database-backup-encryption/ Sun, 08 May 2016 13:55:27 +0000 http://codingsight.com/?p=36 To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup encryption feature. In this article, we will talk about encryption options available in SQL Server for database backups. We will have a closer look at the usage details, benefits, and recommended …

The post SQL Server Database Backup Encryption appeared first on {coding}Sight.

]]> SQL Server Transaction Log — Part 2 https://codingsight.com/dive-into-sql-server-transaction-log-part-3/ Thu, 29 Oct 2015 15:05:29 +0000 http://codingsight.com/?p=57 This is the second article in the series dedicated to SQL Server transaction log and its specificities. Here we are going to examine the log record details. Log Records Log records are the core of the logging and recovery mechanisms. A log record describes a single change in a database. Thus, every change to a …

The post SQL Server Transaction Log — Part 2 appeared first on {coding}Sight.

]]>