Finally, just minutes away the CTP2 of Microsoft SQL Server 2022 launched, get it now and try it

It is with my greatest satisfaction I proudly can introduce Microsoft SQL Server 2022, CTP2. Read more about the new version here, What's new in SQL Server 2022 - SQL Server | Microsoft Docs.

And download the Public Preview here, SQL Server 2022 Preview Trial (microsoft.com)

If you're not registered for msbuild and watching the news now, jump over here, https://mybuild.microsoft.com/en-US/home.

I'm busy watching all the announcements at the moment, more will come.


Really, is the backup running?

Yes, and now you launched all those backup statements, and you wonder when they are done...
This simple Query might help you a bit.

 d.name as database_name,
 DATEDIFF(SECOND, start_time, GETDATE()) AS elapsed_time_in_seconds,
 percent_complete AS estimated_percent_complete,
 DATEADD(SECOND, ROUND(DATEDIFF(SECOND, start_time, GETDATE()) / percent_complete * 100.0, 0), start_time) AS estimated_finish_time
FROM sys.dm_exec_requests r INNER JOIN sys.databases d ON r.database_id = d.database_id WHERE command LIKE '%BACKUP%' OR command LIKE '%RESTORE%'