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

I got the following error:

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

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

When I tried to take a log Backup via Management Studio by doing the mentioned steps below: Continue reading BACKUP LOG cannot be performed because there is no current database backup in SQL Server

Advertisements

Query Task Hierarchy of a subtask using SQL In Project Server

In the previous article, I discussed How to display the Task Hierarchy within My Assignment view inside Tasks section in Project Server 2013,

In this article, I will elaborate How to query this field from ProjectWebApp Database in Project Server 2013?

My scenario

I have a project schedule as shown below:

Tasks Schedule

I need to query the Task Hierarchy for each task in this project via SQL to looks like

Task Hierarchy 2

Steps: Continue reading Query Task Hierarchy of a subtask using SQL In Project Server

Extend the Extended SQL Server Trial Period

In the previous “SQL Server evaluation period has expired, How to extend it?” article, I have explained How to extend the evaluation period for SQL Server 2012?.

In this hint, I will try to answer the below questions:

  • How to Extend the SQL Server Evaluation Period?
  • What happened after the extended SQL Server evaluation period has expired again?
  • Can I Extend the extended SQL Server evaluation period after it expired again?

How to Extend the SQL Server Evaluation Period?

Continue reading Extend the Extended SQL Server Trial Period