Call the BackupInfo method to retrieve information about a backup from the backup file specified by the BackupName parameter. The description for the backup is returned via the BackupDescription parameter. The date and time of the backup is returned via the BackupDateTime parameter. The tables that were backed up are returned via the BackupTables parameter.
The BackupName parameter can contain a full path and file name, however when calling this method from within a remote session for a remote database you must make sure that the path is relative to the database server, not the client workstation.