MSSQL

I wanted to write this article because it has been mentioned in the topic “How To Shrink SQL Server Transaction Log” and there are some …

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 …

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 …