Hi All I am trying to expire all my data except the latest active version. My backup copy group settings are as follows:-
Policy Domain Name WINDOWS Policy Set Name ACTIVE Mgmt Class Name WINDOWS Copy Group Name STANDARD Versions Data Exists 1 Versions Data Deleted 0 Retain Extra Versions 0 Retain Only Version 0 Copy Mode MODIFIED Copy Serialization DYNAMIC Copy Frequency 0 Copy Destination WINDOWS Last Update Date/Time 2002-12-20 07:52:24.000000 Last Update by (administrator) ADMIN Managing profile - However when I use a select statement just to look at one file to see its status this is what I see:- select * from backups where node_name='ALSBCK' and ll_name='BOOT.INI' Operation Results NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 28209279 BACKUP_DATE: 2002-12-20 00:10:03.000000 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 21347128 BACKUP_DATE: 2002-10-29 19:41:41.000000 DEACTIVATE_DATE: 2002-11-04 23:57:37.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22179567 BACKUP_DATE: 2002-11-04 23:57:37.000000 DEACTIVATE_DATE: 2002-11-05 21:13:14.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22618038 BACKUP_DATE: 2002-11-05 21:13:14.000000 DEACTIVATE_DATE: 2002-11-06 19:36:13.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22875347 BACKUP_DATE: 2002-11-06 19:36:13.000000 DEACTIVATE_DATE: 2002-11-11 19:41:46.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 23481388 BACKUP_DATE: 2002-11-11 19:41:46.000000 DEACTIVATE_DATE: 2002-11-19 17:15:50.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 24304303 BACKUP_DATE: 2002-11-19 17:15:50.000000 DEACTIVATE_DATE: 2002-11-29 09:41:35.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 25991488 BACKUP_DATE: 2002-11-29 09:41:35.000000 DEACTIVATE_DATE: 2002-11-29 23:46:42.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 26097958 BACKUP_DATE: 2002-11-29 23:46:42.000000 DEACTIVATE_DATE: 2002-12-01 21:59:49.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 26259332 BACKUP_DATE: 2002-12-01 21:59:49.000000 DEACTIVATE_DATE: 2002-12-02 23:07:36.000000 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 26442741 BACKUP_DATE: 2002-12-02 23:07:36.000000 DEACTIVATE_DATE: 2002-12-05 12:05:07.000000 OWNER: CLASS_NAME: DEFAULT There is still a whole lot of inactive files available some as far back as a month. The expire command i'm using is <expi i w=n> and some files where delete according to the query process however nowhere near enough as can be seen from the select statement. Help I need to get this done to restructure our TSM server:- Kind Regards LAWRIE SCOTT