Thanks all so far, I still do not have any feedback from our AV provider,

But if I have an answer I will share it here as well.

Peter

Hello,

We use Sentinel AV software. And yes, when disabled the entries for the FULL backups are gone as well.

Peter

Hi,

That is the point. There is no external third party tool doing that backup.

Here another log of the backups done only via SQLwhere you can see that  row 3 and...

Well, it is not really an error, it just freezes the disks to take a snapshot, or a shadow copy or something.

The list I showed has the first line having...

I think you pointed me in the correct direction. I did not had a listener.

Checking this now. if that brings the solution for my issue.

In short --> An always on cluster sends log files from the primary server to the other server(s). (like mirror databases or transaction log shipping)
During the time the always...

Extra info, I made it like this to see the exact days hours etc

SELECT T1.Number, T1.StartDate as [New], T2.StartDate as [Assigned],

CAST ((datediff (ss, T1.StartDate, T2.StartDate)/3600/24) AS varchar (2)) +...

Thanks,

I needed to play a bit around to get the data the same way you had. Using a table variable now, but the last line with the cross apply did...

Thanks,

I needed to make some small changes because it was only part of a complete script, but I got it working.

And also understand the query itself.

Peter

Thanks for this reply.

The current_timestamp is from SQL, it work fine.

And the query itself is part of a scripts, so the rows are already calculate.

But anyway, I will see what...

Thanks, that was the solution for me.

Ah thanks,

That worked.

Just was too focused into getting a SET statement, but doing it directly in a SELECT is way easier.

Peter

Yes, yours is working great now. thanks a lot

Yes, it works.

Thanks, now I can dig into the script what it really does so I can also try to understand.

Thanks very much.

Still not working with the newest queries I got, same error withe the group by clause (even twice this time)

Maybe this is more difficult then expected. because if I use...