Can I Delete SQL Server Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files in SQL …
Read More »
Can I Delete SQL Server Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files in SQL …
Read More »Why we want to add second log file? It is a process that we usually perform when there is no free space in the disk …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »