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 AT vm.marist DOT edu> wrote on 01/27/2011
09:46:23 AM:
>> From: Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
>> To: ADSM-L AT vm.marist DOT edu
>> Date: 01/27/2011 09:52 AM
>> Subject: MS-SQL TDP questions/issues
>> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT 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
>> zforray AT vcu DOT 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
|
