> Am I remembering this wrong and confusing it with other TDP's (oracle)? > How does it expire old versions?
Gerald, You are remembering this correctly. All objects sent to the TSM backup storage pool by the SQL Application Client are given a unique name so they are never expired by the TSM server. The SQL Application Client provides a delete function to remove unwanted backup objects from the TSM server. However, the VERDeleted parameter of the Backup Copy Group should be set to 0 (zero). When the SQL Application Client marks a backup object inactive, that object is deleted from the TSM server the next time expiration processing occurs. A backup object is marked inactive when you delete it through the SQL Application Client interface. The above text was taken from the version 1 TDP for SQL Installation and User's Guide. A copy of the User's Guide should be in the (base-dir)\MSSQL\HTM directory. It is called "ab5msmst.htm". If it is not there, you may have chosen not to install it... and in this case you can get it from your original CD. It is covered in Chapter 3 under a section titled: "TSM Policy Requirements and Recommendations". Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] "It's a beautiful day. Don't let it get away." -- Bono
