Listing a server’s backup objects

Use the sp_querysmobj stored procedure to retrieve a list of a server’s backup objects. See the Reference Manual: Procedures for complete syntax and usage information.