Maintenance Plan

Shrink Transaction Log File Maintenance Plan in SQL Server 2017

Shrink a Transaction Log File Maintenance Plan in SQL Server 2016

When I tried to create a “Shrink a transaction log file Maintenance Plan in SQL Server”, I have noted that the shrink option in Maintenance Tasks includes a shrinking operation for both data file and transaction log file, and there is not an option for only log file! Therefore, In this article, we’ll concentrate to perform a …

Shrink a Transaction Log File Maintenance Plan in SQL Server 2016 Read More »

Transaction LOG BACKUP Maintenance Plan

Create Transaction LOG BACKUP Maintenance Plan in SQL Server

In this article, we will explain how to create Transaction LOG BACKUP Maintenance Plan as well as we will learn how to restore transaction Log Backup in SQL Server? Applied To SQL Server 2017. SQL Server 2016. SQL Server 2012. What’s Transaction LOG BACKUP? Each database has two main types of files, Data file, and …

Create Transaction LOG BACKUP Maintenance Plan in SQL Server Read More »