Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, 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 are stored in transaction log …

I will share how to change the database recovery model in this article. You can find the answer of the “What is recovery model” question in detail in the article …

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 of the transaction log file. …

Recovery model is a database property that controls how transactions are logged. Depending on the Recovery Model, you may or may not use some high availability options, you may or …

If you regularly backup transaction log of your database that uses full recovery model, it truncates the Transaction Log file after each log backup under normal conditions. Thus, this prevents …

In this article, we will configure MSDTC(Microsoft Distributed Transaction Coordinator) for an application that will connect to SQL Server with MSDTC. First open component services. Open Component Services Click Start->Run …