Usecase: MSSQL Database is hosted in the cloud, I download the database thrue FTP and restore it on-premise automatically for reporting.
Now I want to retrieve the date/time when the backup was made, from the restored database, to show my users how old the data is that they are working with.
In my local MSDB, I only see when the database was restored, not when it was originally back-upped in the cloud. I know the date-time is in the .bak, but that is hard to query.
Any suggestions?