Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Before shrinking the SQL Server log file, I recommend you read articles “What is SQL Server Transaction Log” and  “What is Database Recovery Model” that …

When we create filesystem on ZFS, mount process happens by default and mount point created. This mount point can then be mounted on the linux …

SQL Server Transaction Log is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions …

In this article, we will change database recovery model in SQL Server via SSMS or script. Also I will share scripts to to find recovery …

Database Checkpoint process is one of the most important part of SQL Server Architecture. Before you read this article, you need to understand the significance …

This article contains information about database recovery mode in SQL Server. You will find many information about FULL,SIMPLE and BULK LOGGED Recovery models and differences …

If you regularly backup your sql server transaction log of your database that uses full recovery model, it truncate the Transaction Log file after each …

In this article, we will explain what is MSDTC and configure MSDTC(Microsoft Distributed Transaction Coordinator) for an application that will connect to SQL Server with …