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 »

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