Procedures Related to BackupSet

• Muneeb Ahmed

  Say Hey Kid

  Points: 677

  More actions

  March 19, 2004 at 1:31 pm

  #152081

  Hi,

  Are there any procedures in SQLServer related to backupset. I mean that does SQLServer comes with any stored procedures that I can use to get the information about the Backupset for example: How may backupsets are in Transaction log file things like that....I know I can use the RESTORE HEADERONLY command but I'm interested in stored procedures.

  Thanx.

  Muneeb.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 19, 2004 at 4:14 pm

  #499618

  If you mean details of a backup then kinda, look the following tables in msdb database.

  backupmediafamily

  backupmediaset

  backupset

  but no SPs other than to delete history and I haven't taken time to build any myself.