Tag: transaction log

SQL Server Transactional Replication Configuration

Database administation, SQL Server, Transaction Log

Transactional Replication in SQL Server is one of the most commonly used Replication techniques to...
Read More

SQL Server Transactional Replication Internals – Part 2

Database administation, Transaction Log

SQL Server Transactional Replication is one of the most commonly used replication techniques used to copy or distribute data across...
Read More

SQL Server Transactional Replication Internals

Database administation, Transaction Log

SQL Server Transactional Replication is one of the most common Replication techniques used to share, copy, or distribute data to multiple...
Read More

Basics of SQL Server Transaction Log

Database administation, Transaction Log

What is a Transaction Log? There is a requirement in relational database systems that transactions...
Read More

Configure SQL Server Log Shipping

Database administation, Transaction Log

This article explains the step by step deployment process of the SQL Server Log shipping. It is the database-level disaster recovery...
Read More

Creating Maintenance Plans in SQL Server

Database administation, Database Optimization & Structure

Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the...
Read More

Using Trace Flag 3226 to Suppress Log Backup Logging

Database administation, Transaction Log

Introduction Every backup operation in SQL Server is written to the SQL Server Error log. This...
Read More

Importance of transaction log in SQL Server

Database administation, Transaction Log

Transaction logs are a vital and important component of database architecture. In this article, we’ll discuss SQL Server transaction...
Read More

Fixing Data Loss Using Log Shipping with Delayed Recovery

Database administation, Transaction Log, Troubleshooting Issues

Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to maintain a copy of the live database in the...
Read More

SQL Server Database Backup Encryption

Database administation, Security

To manage the data security that has been backed up by the file system as a database backup files,...
Read More
Close