SQL Server 2017

How to Check Network Connectivity between Application Server and Database Server

How to Check SQL Server Connectivity between Application Server and Database Server

In this article, we will explain How to check SQL Server Connectivity between application server and database server for a specific user. by exploring the folloiwng: You might also like to read SQL Server Best Practices for SharePoint 2019. Check the connectivity between Application Server and SQL Server Instance in Database Server To check SQL …

How to Check SQL Server Connectivity between Application Server and Database Server 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 »