Hello all, I am busy doing some SQL Server backups, and my goal is:
- Do full backups on sundays. - Differential backups on the other days. - Be able to restore any of the backups in a 30 days window I defined a management class specifying Verexists=30 and RetExtra=30 and made some tests: 1. When I run the full backup, I get an active version (OK) 2. When I run the differentials (3 of them), I get one active version and two inactive versions. Still OK 3. When I run another full backup, what happens: I see (in the TSM foor SQL restore GUI) two full backups (one active and one inactive), but I see only the last differential made (marked inactive). Looking in the BACKUPS table, I see that the two other differentials still exist in the database, but with their inactivate date set as follows: NODE_NAME: TRIUNFO-SQL FILESPACE_NAME: TRIUNFO\data\0001 FILESPACE_ID: 6 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \model\ LL_NAME: difffull OBJECT_ID: 35879 BACKUP_DATE: 2003-07-09 12:02:02.000000 DEACTIVATE_DATE: 1900-01-01 00:00:00.000000 OWNER: CLASS_NAME: MC-SQL And I can't see them in the restore window. Any hints? -- Paul Gondim van Dongen Engenheiro de Sistemas MCSE IBM Tivoli Storage Manager Certified Consultant VANguard - Value Added Network guardians http://www.vanguard-it.com.br Fone: 55 81 3225-0353