SQL Server 2008

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 »

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 »