How can I get the backups of the last 24 hours of the SQLServer?

Badge +1

I am trying to get the different backups from the sql database, but I can't find the way without having to go through client, instances....

2 replies

Userlevel 5
Badge +12

@alexmc ,

You can run the Backup job summary report and filter on the client. This will give you all of the backups that ran for the client within the time frame you are looking for.


Edward J Holowienka

Userlevel 6
Badge +18

You can go to Job History under the Jobs section in Command Center.
You can apply any necessary filters to pick by Server and/or Agent type.
If you do this regularly, save the Filters as a View and jump to it real quick.