MS-SQL TDP questions/issues
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
Re: MS-SQL TDP questions/issues
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
Re: TDP questions
Managing expiration is the job of the TDP or application software. Ordinarily a new filename is used for every new backup, and TSM hangs onto the file until it is specifically deleted by the TDP. A point of clarification... This is not always true... for example, with TDP for Domino 1.1, TDP for Exchange 2.2 and TDP for SQL 2.2, expiration is controlled by the TSM Server policy settings. The TDP application does not control expiration. Historically speaking... With TDP for SQL 1.1 and TDP for Exchange 1.1 expiration was controlled by running a delete command with the TDP client. That was changed when version 2.2 came out. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] Celebrate we will. Life is short but sweet for certain... -- Dave
TDP questions
Where do I find out how many backups TDP keeps. How do we know when a successful backup took place via TDP? Thanks Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: TDP questions
Depending on how you do expiration TDP keeps as many backups as your archive management class has specified and the frequency you run expiration. You can check to see a successful backup either via the Administrative Assistant if you purchased it or looking at the log files. I know for TDP for SAP R/3 our log files are kept in /oracle/SID/sapbackup. Becky -Original Message- From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 8:14 AM To: [EMAIL PROTECTED] Subject: TDP questions Where do I find out how many backups TDP keeps. How do we know when a successful backup took place via TDP? Thanks Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: TDP questions
What TDP application are you using? -- Joshua S. Bassi Sr. Solutions Architect IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (415) 215-0326 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Hunley, Ike Sent: Thursday, January 31, 2002 6:14 AM To: [EMAIL PROTECTED] Subject: TDP questions Where do I find out how many backups TDP keeps. How do we know when a successful backup took place via TDP? Thanks Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: TDP questions
TDP for Informix, Oracle and Exchange. -Original Message- From: Joshua S. Bassi [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 4:36 PM To: [EMAIL PROTECTED] Subject: Re: TDP questions What TDP application are you using? -- Joshua S. Bassi Sr. Solutions Architect IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (415) 215-0326 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Hunley, Ike Sent: Thursday, January 31, 2002 6:14 AM To: [EMAIL PROTECTED] Subject: TDP questions Where do I find out how many backups TDP keeps. How do we know when a successful backup took place via TDP? Thanks Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc. Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: TDP questions
The TDPs tend to create separate filespaces for the database objects. I usually do a q occ report and see how many objects there are in the filespace for the database. Indirect but efficient. Managing expiration is the job of the TDP or application software. Ordinarily a new filename is used for every new backup, and TSM hangs onto the file until it is specifically deleted by the TDP. _ William Mansfield Senior Consultant Solution Technology, Inc 630 718 4238 Hunley, Ike Ike.Hunley@BCBSFTo: [EMAIL PROTECTED] L.COM cc: Sent by: ADSM: Subject: TDP questions Dist Stor Manager [EMAIL PROTECTED] .EDU 01/31/2002 08:14 AM Please respond to ADSM: Dist Stor Manager Where do I find out how many backups TDP keeps. How do we know when a successful backup took place via TDP? Thanks Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.