Maintenance Plan

Shrink a Transaction Log File Maintenance Plan in SQL Server 2016

Shrink Transaction Log File Maintenance Plan in SQL Server 2017

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 »

Create Transaction LOG BACKUP Maintenance Plan in SQL Server

Transaction LOG BACKUP Maintenance Plan

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 »

Scroll to Top