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

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 …

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 reading this article, you might want to read the article “How To Create a FileSystem on ZFS (Mount Point)” to create a mount point on …

In Postgres you could be managing many databases on a Cluster. In some cases you may need to query the size all of these databases. …

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 …