question

ruancra avatar image
ruancra asked

Get list of databases backed up in a sql job

Hi all Is it possible to retrieve a list of database names backed up in a sql job? We currently use Redgate to do our backups, when creating a backup schedule with Redgate it creates a sql job. Wanted to know if we can get this info from msdb or somewhere else? Thanks
backupsql2014msdbredgate
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
raadee avatar image
raadee answered
Hi, Check out these scripts by Tim Ford. [Backup history script][1] [1]: http://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image raadee commented ·
Misread, the specific job.. Only thing I can come up with, if it is a one time check, is to go to the sql log and check which databases were backed up at the time the job ran.
2 Likes 2 ·
ruancra avatar image ruancra commented ·
Thanks, but i'm looking for something to get a list of databases backed up in a specific job (a Redgate backup job in this case.)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.