Zoltan, For the first problem, please open a PMR with IBM.
For the second problem, it appears that you are not binding the log backups to a management class that will remove them correctly. There is discussion in the User's Guide that talks about setting this up. Log backups are uniquely named. This means that when a full backup is rung, they will go inactive. Once they go inactive, the RETONLY parameter will control their deletion. In addition, if you are running the FULL backups to a different nodename, the log backup will never go inactive.. and will stay around forever. Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> wrote on 01/27/2011 09:46:23 AM: >> From: Zoltan Forray/AC/VCU <zfor...@vcu.edu> >> To: ADSM-L@vm.marist.edu >> Date: 01/27/2011 09:52 AM >> Subject: MS-SQL TDP questions/issues >> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> >> >> My MS-SQL guy asked me to pass these questions/issues along: >> >> I have another gripe about TDP, if you could submit this as well. A while >> back (not sure what version it started with), on some of the servers the >> database list isn't sorted alphabetically. So I have to search through >> the list when I need to do a single backup manually. There doesn't appear >> to be a way to re-sort it either (click the column headings does nothing) >> >> ............. >> >> Just thought of another issue if you wanted to pass it along. The reason >> I have to split the fulls and diffs on different nodes from the log >> backups is because the log backups don't seem to go away after they're 30 >> days old (the fulls and diffs do like they're supposed to). So if I need >> to pull up an old backup from 3 weeks ago and I choose "Show Active and >> Inactive" backups, the logs take forever to come up because there are so >> many it has to go and find. I could be doing something wrong, but the >> dsm.opt files are basically the same for all 3 types of backups (just >> pointing to the different nodes), and only the log backups aren't going >> away. >> Zoltan Forray >> TSM Software & Hardware Administrator >> Virginia Commonwealth University >> UCC/Office of Technology Services >> zfor...@vcu.edu - 804-828-4807 >> Don't be a phishing victim - VCU and other reputable organizations will >> never use email to request that you reply with your password, social >> security number or confidential personal information. For more details >> visit http://infosecurity.vcu.edu/phishing.html
