Re: Q Backupsetcontents

[Richard Sims]

>Are the contents of a backupset kept in the database or in the backupset
>itself?

In the Backup Set itself.  Indeed, from the Admin Ref doc for the
Query BACKUPSETCONTENTS command:

   Be aware that processing this command can use considerable network
   resources and mount points.

That is, it has to mount the media and harvest information from it.
It's a worthwhile compromise design, given the nature of this kind of
convenience backup.

   Richard Sims, BU