Parent Directory | Revision Log
returns all increments which are stored on single DVD
1 | dpavlin | 299 | -- display all files (increments) on one DVD |
2 | select | ||
3 | hosts.name, | ||
4 | shares.name, | ||
5 | backups.num, | ||
6 | backups.date::abstime, | ||
7 | backups.type, | ||
8 | backups.size, | ||
9 | backups.parts, | ||
10 | backups.inc_size, | ||
11 | backups.inc_deleted | ||
12 | from archive_backup | ||
13 | join archive on archive_id = archive.id | ||
14 | join backups on backup_id = backups.id | ||
15 | join shares on shareid = shares.id | ||
16 | join hosts on backups.hostid = hosts.id | ||
17 | where dvd_nr = 14 ; |
ViewVC Help | |
Powered by ViewVC 1.1.26 |