SQL Server 2019

Get SQL Server Info Using SERVERPROPERTY

How to 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. Download the full SQL Query from GitHub at Get The Detailed SQL Server Information. What’s …

How to Get SQL Server Info Using SERVERPROPERTY? Read More »

How to get the update level in SQL Server 2016

Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed in your environment!! In this article, we will explain How to get the update level in SQL Server 2016 and detect the current installed Cumulative Update / …

How to get the update level in SQL Server 2016 Read More »

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 »