SQL Server 2016

BACKUP LOG cannot be performed because there is no current database backup

BACKUP LOG cannot be performed because there is no current database backup in SQL Server 2017

In this post, we will solve “BACKUP LOG cannot be performed because there is no current database backup” that we have faced when we tried to take a transaction log backup in SQL server 2017. Applies To SQL Server 2019. SQL Server 2017. SQL Server 2016. SQL Server 2014. SQL Server 2012. Transaction Log Backup …

BACKUP LOG cannot be performed because there is no current database backup in SQL Server 2017 Read More »

Extend SQL Server Evaluation Period

Extend SQL Server Evaluation Period: SQL Server Evaluation Period has expired

In this post, we’ll explain How to extend SQL Server evaluation period to avoid “SQL Server Evaluation Period has expired” when we open SQL Server Management Studio. We’ll also go through the following: You may also like to read SQL Server Evaluation Period has expired after upgrade, how to extend it? SQL Server Evaluation Period …

Extend SQL Server Evaluation Period: SQL Server Evaluation Period has expired Read More »

Dynamic pivot without aggregate function in SQL Server

In this article, we will learn How to create a dynamic pivot without aggregate function in SQL Server? You might also like to read Convert Rows To Columns Using Dynamic Pivot In SQL Server Dynamic pivot without aggregate function in SQL Server I have the below three tables (One-Many relations) The 1st table (Table) holds …

Dynamic pivot without aggregate function in SQL Server Read More »