SQL Server 2014

How to get the update level in SQL Server 2016

Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed in your environment!! In this article, we will explain How to get the update level in SQL Server 2016 and detect the current installed Cumulative Update / …

How to get the update level in SQL Server 2016 Read More »

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 »