SQL Server 2012

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 »

Install and Configure SSRS step by step

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). In this article, we will learn How to install and configure SSRS Native Mode step by step. You …

Install and Configure SSRS step by step 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 »