SQL Server 2014

Get SQL Server Info Using SERVERPROPERTY()

In this article, we will explain how to Get SQL Server info using SERVERPROPERTY, we will also provide a complete SQL Query to get all detailed information of the current installed SQL Server, like version, instance name, build number …etc. You might also like to read SQL Server Best Practices for SharePoint 2019 What’s the SERVERPROPERTY …

Get SQL Server Info Using SERVERPROPERTY() 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 »