Re: TDP for SQL Server password file

[Loon, Eric van (ITOP NS) - KLM]

Hi Leandro,

Thank you very much for your help!

Kind regards,
Eric van Loon
Air France/KLM Storage & Backup

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of L Mazur
Sent: vrijdag 11 december 2020 19:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server password file

Hi Eric,

For versions prior to 7.1.8/8.1.2, I find the password registry entry in the 
path below:

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\ADSM\CurrentVersion\Nodes

There you'll find node name and under that the server name with the password 
key.

>From versions 7.1.8/8.1.2, the registry key is empty and the password files I 
>find in the path below:

C:\ProgramData\Tivoli\TSM\baclient\Nodes

Hope it helps.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, 
Eric van (ITOP NS) - KLM
Sent: sexta-feira, 11 de dezembro de 2020 13:38
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL Server password file

Hi Del,

Any idea which registry key is used? Thanks for your help!

Kind regards,
Eric van Loon
Air France/KLM Storage & Backup

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Del Hoobler
Sent: vrijdag 11 december 2020 17:02
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server password file

Hi Eric,

If you cannot find anything in the Windows registry, please open a ticket with 
IBM.

I spoke to the developers and they are not entirely sure of the use/case 
scenario that would lead to this.

Thank you,

Del



"ADSM: Dist Stor Manager"  wrote on 12/10/2020
05:15:14 AM:

> From: "Loon, Eric van (ITOP NS) - KLM" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 12/10/2020 05:16 AM
> Subject: [EXTERNAL] TDP for SQL Server password file Sent by: "ADSM:
> Dist Stor Manager" 
>
> Hi guys,
>
> We have some SQL Server clients which have the wrong password stored 
> through the GUI. The only problem is that the GUI only allows you to 
> update the password when you know the old password. So I need to know 
> where the TDP for SQL Server client stores his password, so I can 
> delete this file. Who can help me out here? Thanks in advance!
>
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
> 
> For information, services and offers, please visit our web site:
> INVALID URI REMOVED
> u=http-3A__www.klm.com=DwIFAg=jf_iaSHvJObTbx-
>
siA1ZOg=0hq2JX5c3TEZNriHEs7Zf7HrkY2fNtONOrEOM8Txvk8=qTYagUtxsvKwzIwjPrVp
6_nr58CEzPHUhog96Ww_V1Y=TxheWDAomPMxZEDhx4tQGUVhP7vFiOcojv1d4OdadP0=
> . This e-mail and any attachment may contain confidential and 
> privileged material intended for the addressee only. If you are not 
> the addressee, you are notified that no part of the e-mail or any 
> attachment may be disclosed, copied or distributed, and that any other 
> action related to this e-mail or attachment is strictly prohibited, 
> and may be unlawful. If you have received this e-mail by error, please 
> notify the sender immediately by return e-mail, and delete this 
> message.
>
> Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or 
> its employees shall not be liable for the incorrect or incomplete 
> transmission of this e-mail or any attachments, nor responsible for 
> any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
> Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
> registered number 33014286
> 
>

For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286


For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the a

Re: TDP for SQL Server password file

[L Mazur]

Hi Eric,

For versions prior to 7.1.8/8.1.2, I find the password registry entry in the
path below:

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\ADSM\CurrentVersion\Nodes

There you'll find node name and under that the server name with the password
key.

>From versions 7.1.8/8.1.2, the registry key is empty and the password files
I find in the path below:

C:\ProgramData\Tivoli\TSM\baclient\Nodes

Hope it helps.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Loon, Eric van (ITOP NS) - KLM
Sent: sexta-feira, 11 de dezembro de 2020 13:38
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL Server password file

Hi Del,

Any idea which registry key is used? Thanks for your help!

Kind regards,
Eric van Loon
Air France/KLM Storage & Backup

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Del
Hoobler
Sent: vrijdag 11 december 2020 17:02
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server password file

Hi Eric,

If you cannot find anything in the Windows registry, please open a ticket
with IBM.

I spoke to the developers and they are not entirely sure of the use/case
scenario that would lead to this.

Thank you,

Del



"ADSM: Dist Stor Manager"  wrote on 12/10/2020
05:15:14 AM:

> From: "Loon, Eric van (ITOP NS) - KLM" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 12/10/2020 05:16 AM
> Subject: [EXTERNAL] TDP for SQL Server password file Sent by: "ADSM:
> Dist Stor Manager" 
>
> Hi guys,
>
> We have some SQL Server clients which have the wrong password stored
> through the GUI. The only problem is that the GUI only allows you to
> update the password when you know the old password. So I need to know
> where the TDP for SQL Server client stores his password, so I can
> delete this file. Who can help me out here? Thanks in advance!
>
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
> 
> For information, services and offers, please visit our web site:
> INVALID URI REMOVED
> u=http-3A__www.klm.com=DwIFAg=jf_iaSHvJObTbx-
>
siA1ZOg=0hq2JX5c3TEZNriHEs7Zf7HrkY2fNtONOrEOM8Txvk8=qTYagUtxsvKwzIwjPrVp
6_nr58CEzPHUhog96Ww_V1Y=TxheWDAomPMxZEDhx4tQGUVhP7vFiOcojv1d4OdadP0=
> . This e-mail and any attachment may contain confidential and
> privileged material intended for the addressee only. If you are not
> the addressee, you are notified that no part of the e-mail or any
> attachment may be disclosed, copied or distributed, and that any other
> action related to this e-mail or attachment is strictly prohibited,
> and may be unlawful. If you have received this e-mail by error, please
> notify the sender immediately by return e-mail, and delete this
> message.
>
> Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or
> its employees shall not be liable for the incorrect or incomplete
> transmission of this e-mail or any attachments, nor responsible for
> any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
> Dutch Airlines) is registered in Amstelveen, The Netherlands, with
> registered number 33014286
> 
>

For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered
number 33014286

Re: TDP for SQL Server password file

[Loon, Eric van (ITOP NS) - KLM]

Hi Del, 

Any idea which registry key is used? Thanks for your help!

Kind regards,
Eric van Loon
Air France/KLM Storage & Backup

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Del Hoobler
Sent: vrijdag 11 december 2020 17:02
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server password file

Hi Eric,
 
If you cannot find anything in the Windows registry, please open a ticket with 
IBM.
 
I spoke to the developers and they are not entirely sure of the use/case 
scenario that would lead to this.
 
Thank you,
 
Del



"ADSM: Dist Stor Manager"  wrote on 12/10/2020
05:15:14 AM:

> From: "Loon, Eric van (ITOP NS) - KLM" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 12/10/2020 05:16 AM
> Subject: [EXTERNAL] TDP for SQL Server password file Sent by: "ADSM: 
> Dist Stor Manager" 
> 
> Hi guys,
> 
> We have some SQL Server clients which have the wrong password stored 
> through the GUI. The only problem is that the GUI only allows you to 
> update the password when you know the old password. So I need to know 
> where the TDP for SQL Server client stores his password, so I can 
> delete this file. Who can help me out here? Thanks in advance!
> 
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
> 
> For information, services and offers, please visit our web site: 
> INVALID URI REMOVED
> u=http-3A__www.klm.com=DwIFAg=jf_iaSHvJObTbx-
> 
siA1ZOg=0hq2JX5c3TEZNriHEs7Zf7HrkY2fNtONOrEOM8Txvk8=qTYagUtxsvKwzIwjPrVp6_nr58CEzPHUhog96Ww_V1Y=TxheWDAomPMxZEDhx4tQGUVhP7vFiOcojv1d4OdadP0=
> . This e-mail and any attachment may contain confidential and 
> privileged material intended for the addressee only. If you are not 
> the addressee, you are notified that no part of the e-mail or any 
> attachment may be disclosed, copied or distributed, and that any other 
> action related to this e-mail or attachment is strictly prohibited, 
> and may be unlawful. If you have received this e-mail by error, please 
> notify the sender immediately by return e-mail, and delete this 
> message.
> 
> Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or 
> its employees shall not be liable for the incorrect or incomplete 
> transmission of this e-mail or any attachments, nor responsible for 
> any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
> Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
> registered number 33014286
> 
> 

For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL Server password file

[Marc Lanteigne]

Hi Eric,

The old password is the current password. In my example below, I set the
new password the same as the current, but it could be different.

Protect: HYDROGEN>update node test test1234
ANR2063I Node TEST updated.

Protect: HYDROGEN>quit

ANS8002I Highest return code was 0.


c:\Program Files\Tivoli\TSM\baclient>dsmc  set password test1234 test1234
-nodename=test
IBM Spectrum Protect
Command Line Backup-Archive Client Interface
  Client Version 8, Release 1, Level 8.0
  Client date/time: 12/11/2020 12:27:50
(c) Copyright by IBM Corporation and other(s) 1990, 2019. All Rights
Reserved.

Password updated.

Session established with server HYDROGEN: Linux/x86_64
  Server Version 8, Release 1, Level 10.000
  Server date/time: 12/11/2020 08:27:28  Last access: 12/11/2020 08:27:26


c:\Program Files\Tivoli\TSM\baclient>

-
Thanks,
Marc...

Marc Lanteigne
Spectrum Protect Specialist AVP / SRT
IBM Systems, Spectrum Protect / Plus
+1-506-460-9074  <- New phone number
marclantei...@ca.ibm.com
Office Hours:  Monday to Friday, 7:00 to 15:30 Eastern

IBM



-Original Message-
From: Loon, Eric van (ITOP NS) - KLM 
Sent: Thursday, December 10, 2020 06:17 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] [ADSM-L] TDP for SQL Server password file

Hi guys,

We have some SQL Server clients which have the wrong password stored
through the GUI. The only problem is that the GUI only allows you to update
the password when you know the old password. So I need to know where the
TDP for SQL Server client stores his password, so I can delete this file.
Who can help me out here? Thanks in advance!

Kind regards,
Eric van Loon
Air France/KLM Storage & Backup

For information, services and offers, please visit our web site:
http://www.klm.com .
 This e-mail and any attachment may contain confidential and privileged
material intended for the addressee only. If you are not the addressee, you
are notified that no part of the e-mail or any attachment may be disclosed,
copied or distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately by
return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any delay in
receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered
number 33014286

Re: TDP for SQL Server password file

[Del Hoobler]

Hi Eric,
 
If you cannot find anything in the Windows registry, please open a ticket 
with IBM.
 
I spoke to the developers and they are not entirely sure of the use/case 
scenario that would lead to this.
 
Thank you,
 
Del



"ADSM: Dist Stor Manager"  wrote on 12/10/2020 
05:15:14 AM:

> From: "Loon, Eric van (ITOP NS) - KLM" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 12/10/2020 05:16 AM
> Subject: [EXTERNAL] TDP for SQL Server password file
> Sent by: "ADSM: Dist Stor Manager" 
> 
> Hi guys,
> 
> We have some SQL Server clients which have the wrong password stored
> through the GUI. The only problem is that the GUI only allows you to
> update the password when you know the old password. So I need to 
> know where the TDP for SQL Server client stores his password, so I 
> can delete this file. Who can help me out here? Thanks in advance!
> 
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
> 
> For information, services and offers, please visit our web site: 
> INVALID URI REMOVED
> u=http-3A__www.klm.com=DwIFAg=jf_iaSHvJObTbx-
> 
siA1ZOg=0hq2JX5c3TEZNriHEs7Zf7HrkY2fNtONOrEOM8Txvk8=qTYagUtxsvKwzIwjPrVp6_nr58CEzPHUhog96Ww_V1Y=TxheWDAomPMxZEDhx4tQGUVhP7vFiOcojv1d4OdadP0=
> . This e-mail and any attachment may contain confidential and 
> privileged material intended for the addressee only. If you are not 
> the addressee, you are notified that no part of the e-mail or any 
> attachment may be disclosed, copied or distributed, and that any 
> other action related to this e-mail or attachment is strictly 
> prohibited, and may be unlawful. If you have received this e-mail by
> error, please notify the sender immediately by return e-mail, and 
> delete this message.
> 
> Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/
> or its employees shall not be liable for the incorrect or incomplete
> transmission of this e-mail or any attachments, nor responsible for 
> any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
> Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
> registered number 33014286
> 
> 

Re: TDP for SQL and UAC

[Shawn Drew]

Are you executing tdp with "runas" in the script or is control-m agent service 
logged on as the desired domain account?

Thanks,
-Shawn

On Jun 1, 2017, 8:05 PM -0400, Harris, Steven 
, wrote:
> Hi All
>
> I've got a bit of a show-stopper here that I could use some help with.
>
> Previously, SQL backups have been mostly handled by dump to disk and backup 
> with BA Client. Database sizes have grown over time and now we cannot get 
> through the whole dump/backup cycle in a reasonable window, so we have been 
> pushing to get TDP used as the standard backup mechanism for SQL. There are a 
> couple of issues with this ; I'll be submitting an RFE for one of them 
> shortly however the big one is to do with security.
>
> The TDP for SQL backup is to be run using the control-m scheduling tool as 
> the backup has to run at a particular point in the processing cycle (also for 
> restores as we can't afford to have a large restore fail because someone's 
> RDP session timed out) . It must use a domain account, nothing else is 
> permissible. When doing this we get a windows UAC pop-up. Again we are not 
> permitted to turn off UAC.. don't worry about how reasonable that is, IT 
> Security and Auditors don't cope well with arguments about 'reasonable' or 
> 'low risk' it's all black and white.
>
> So, has anyone else solved this issue: run a TDP backup from a domain account 
> and somehow bypass the UAC prompt without turning it off in a blanket fashion?
>
> Any and all suggestions gratefully received.
>
> Steve
>
> Steven Harris
> TSM Admin/Consultant
> Canberra Australia
>
> This message and any attachment is confidential and may be privileged or 
> otherwise protected from disclosure. You should immediately delete the 
> message if you are not the intended recipient. If you have received this 
> email by mistake please delete it from your system; you should not copy the 
> message or disclose its content to anyone.
>
> This electronic communication may contain general financial product advice 
> but should not be relied upon or construed as a recommendation of any 
> financial product. The information has been prepared without taking into 
> account your objectives, financial situation or needs. You should consider 
> the Product Disclosure Statement relating to the financial product and 
> consult your financial adviser before making a decision about whether to 
> acquire, hold or dispose of a financial product.
>
> For further details on the financial product please go to http://www.bt.com.au
>
> Past performance is not a reliable indicator of future performance.

Re: TDP for SQL and UAC

[Del Hoobler]

Hi Steve,

Assuming the user running the DP/SQL client has local administrator 
authority, the customer can disable UAC prompts only for administrators as 
described here: 

 
http://tweaks.com/windows/39115/disable-user-account-control-uac-only-for-administrators/
 


Alternatively, it is possible to disable UAC only for specific programs as 
described here: 

 
http://www.winhelponline.com/blog/run-programs-elevated-without-getting-the-uac-prompt/

and here:

 https://www.youtube.com/watch?v=_WcWJlm_O_k 



Del



"ADSM: Dist Stor Manager"  wrote on 06/01/2017 
07:59:52 PM:

> From: "Harris, Steven" 
> To: ADSM-L@VM.MARIST.EDU
> Date: 06/01/2017 08:01 PM
> Subject: TDP for SQL and UAC
> Sent by: "ADSM: Dist Stor Manager" 
> 
> Hi All
> 
> I've got a bit of a show-stopper here that I could use some help with.
> 
> Previously, SQL backups have been mostly  handled by dump to disk 
> and backup with BA Client. Database sizes have grown over time and 
> now we cannot get through the whole dump/backup cycle in a 
> reasonable window, so we have been pushing to get TDP used as the 
> standard backup mechanism for SQL.  There are a couple of issues 
> with this ; I'll  be submitting an RFE for one of them shortly 
> however the big one is to do with security.
> 
> The TDP for SQL backup is to be run using the control-m scheduling 
> tool as the backup has to run at a particular point in the 
> processing cycle (also for restores as we can't afford to have a 
> large restore fail because someone's RDP session timed out) .  It 
> must use a domain account, nothing else is permissible.  When doing 
> this we get a windows UAC pop-up.  Again we are not permitted to 
> turn off UAC..  don't worry about how reasonable that is, IT 
> Security and Auditors don't cope well with arguments about 
> 'reasonable' or 'low risk' it's all black and white.
> 
> So, has anyone else solved this issue: run a TDP backup from a 
> domain account and somehow bypass the UAC prompt without turning it 
> off in a blanket fashion?
> 
> Any and all suggestions gratefully received.
> 
> Steve
> 
> Steven Harris
> TSM Admin/Consultant
> Canberra Australia
> 
> This message and any attachment is confidential and may be 
> privileged or otherwise protected from disclosure. You should 
> immediately delete the message if you are not the intended 
> recipient. If you have received this email by mistake please delete 
> it from your system; you should not copy the message or disclose its
> content to anyone. 
> 
> This electronic communication may contain general financial product 
> advice but should not be relied upon or construed as a 
> recommendation of any financial product. The information has been 
> prepared without taking into account your objectives, financial 
> situation or needs. You should consider the Product Disclosure 
> Statement relating to the financial product and consult your 
> financial adviser before making a decision about whether to acquire,
> hold or dispose of a financial product. 
> 
> For further details on the financial product please go to 
http://www.bt.com.au
> 
> Past performance is not a reliable indicator of future performance.
> 

Re: TDP for SQL Server, ANS1532E on AlwaysOn cluster

[Loon, Eric van (ITOPT3) - KLM]

Hi Leif!
Thanks for your reply! The strange thing is that this is not mentioned in the 
installation manual. There is only a link called "Proxy node definitions for 
VSS backups" but we are using legacy backups...
Kind regards,
Eric van Loon
Air France/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Leif 
Torstensen
Sent: maandag 14 november 2016 10:45
To: ADSM-L@VM.MARIST.EDU
Subject: SV: TDP for SQL Server, ANS1532E on AlwaysOn cluster

Hi

You need to make a allwayson node on the tsmserver that the tdp node has proxy 
access to

If you are configuring Data Protection for SQL Server in an SQL Server 2012 
environment, specify the Tivoli® Storage Manager node name that is used to back 
up the AlwaysOn availability databases. You can specify the AlwaysOn node name 
by using the alwaysonnode option in the tdpsql.cfg file. For example:

https://www.ibm.com/support/knowledgecenter/SSTFZR_7.1.0/com.ibm.itsm.db.sql.doc/dps_tsk_cfg_sqlserver.html

Med venlig hilsen / Best regards

Leif Torstensen
Backup Technician

t: +45 70253030 | d: +45 63144019
e: l...@athena.dk | w: athena.dk




Fyn: Munkerisvej 1 · 5230 Odense M · t: +45 70 25 30 30
Sjælland: Hørskætten 6A · 2630 Taastrup · t: +45 70 25 30 30
Jylland: Rådhuscentret 41 · 6500 Vojens · t: +45 70 25 30 30




-Oprindelig meddelelse-
Fra: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] På vegne af Loon, 
Eric van (ITOPT3) - KLM
Sendt: 14. november 2016 10:32
Til: ADSM-L@VM.MARIST.EDU
Emne: [ADSM-L] TDP for SQL Server, ANS1532E on AlwaysOn cluster

Hi guys!
Our SQL Server department has installed the TDP client on an AlwaysOn cluster. 
Backing up the local databases (master, model, msdb) works fine, but as soon as 
they make a backup of the secondary database they receive the error ANS1532E 
(RC5722) Proxy Rejected: Proxy authority has not been granted to this node.
On the TSM server side the node is configured exactly like all other 
(non-AlwaysOn) nodes. I don't know where to look for the cause of this error...
We are using legacy backup by the way.
Thanks for any help in advance!
Kind regards,
Eric van Loon
Air France/KLM Storage Engineering

For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286


For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL 7.1.1 restore to another server failure

[Francisco Javier]

your problem is this:

Failed - Error: RC: 418
ANS1025E (RC137)  Session rejected: Authentication failure


Fix and try again =)

Best Regards


2014-12-16 15:53 GMT-06:00 Schaub, Steve steve_sch...@bcbst.com:

 Trying to help our DBA team get a database restored from one server to
 another.  The target server is Windows 2012R2 with TSM  TDP 7.1.1
 When I change the dsm.opt and launch the mmc, get this error:

 Get-DpSqlBackup  -Name * -AllTypes -COMPATibilityinfo -FROMSQLserver *
 -QUERYNode DP -ConfigFile c:\program files\tivoli\tsm\TDPSql\tdpsql.cfg
 -TsmOptFile c:\program files\tivoli\tsm\TDPSql\dsm.opt

 Failed - Error: RC: 418
 ANS1025E (RC137)  Session rejected: Authentication failure
 At Get-DpSqlBackup -Private -Name * -AllTypes -COMPATibilityinfo
 -FROMSQLserver * -QUERYNode DP -ConfigFile c:\program
 files\tivoli\tsm\TDPSql\tdpsql.cfg -TsmOptFile c:\program
 files\tivoli\tsm\TDPSql\dsm.opt
 InvalidResult: (Capability.ImplSql.SqlContext:SqlContext)
 [Get-DpSqlBackup], Exception
 418,IBM.Tivoli.TSM.Cmdlets.SQL.GetDpSqlBackup

 Get-DpSqlBackup  -Name * -AllTypes -All -COMPATibilityinfo -FROMSQLserver
 * -QUERYNode DP -ConfigFile c:\program files\tivoli\tsm\TDPSql\tdpsql.cfg
 -TsmOptFile c:\program files\tivoli\tsm\TDPSql\dsm.opt

 Failed - Error: RC: 418
 ANS1025E (RC137)  Session rejected: Authentication failure
 At Get-DpSqlBackup -Private -Name * -AllTypes -All -COMPATibilityinfo
 -FROMSQLserver * -QUERYNode DP -ConfigFile c:\program
 files\tivoli\tsm\TDPSql\tdpsql.cfg -TsmOptFile c:\program
 files\tivoli\tsm\TDPSql\dsm.opt
 InvalidResult: (Capability.ImplSql.SqlContext:SqlContext)
 [Get-DpSqlBackup], Exception
 418,IBM.Tivoli.TSM.Cmdlets.SQL.GetDpSqlBackup

 Is there something obvious I'm missing?

 Thanks,

 Steve Schaub
 Systems Engineer II, Backup/Recovery
 Blue Cross Blue Shield of Tennessee

 -
 Please see the following link for the BlueCross BlueShield of Tennessee
 E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL server error

[Loon, EJ van (SPLXM) - KLM]

Remco,
It's more than a mistake in an icon. We now have to change our restore 
procedures and tell our users to ignore an error message when they are in the 
GUI or to ignore the configuration wizard when it starts. If they do not ignore 
the wizard and just click the next buttons all configuration files will be 
overwritten and this will cause the BA client to fail!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco 
Post
Sent: woensdag 7 mei 2014 21:02
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL server error

Op 7 mei 2014, om 16:39 heeft Loon, EJ van (SPLXM) - KLM 
eric-van.l...@klm.com het volgende geschreven:

 Hi Del!
 Ok... Hm... I don't think our SQL guys will be very charmed by the work 
 around (ignoring the error)...

not ignore the error, ignore a mistake in an icon... Don't make things bigger 
than they are :)


 And I can't blame them. To my opinion these kind of bugs should not be fixed 
 in a new (maintenance) release but it should be fixed through an immediately 
 available fix release...
 However, thank you VERY much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: woensdag 7 mei 2014 16:21
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error
 
 Hi Eric,
 
 Yes... this is APAR IC99653.
 
   http://www-01.ibm.com/support/docview.wss?uid=swg1IC99653
 
 For now, you can remove the LOCALDSMAGENTNODE option and ignore the red X 
 saying it isn't configured.
 
 You can still perform the legacy backup operations.
 
 
 Del
 
 
 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
 09:40:57 AM:
 
 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 09:41 AM
 Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor 
 Manager ADSM-L@vm.marist.edu
 
 Hi Del!
 The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As 
 soon as he removes this line and starts the TDP GUI the wizard starts 
 with the message that the TDP client has not been configured.
 And when he configures it through the wizard the  LOCALDSMAGENTNODE 
 line is added again... The backup method is set to legacy in the
 tdpsql.cfg
 Thank you very much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: woensdag 7 mei 2014 14:09
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error
 
 Hi Eric,
 
 No. You should just be able to use legacy style backups.
 My guess is that the configuration wizard inadvertently added some 
 entries causing this.
 
 Check the tdpsql.cfg file.
 
 1. Remove the LOCALDSMAGENTNODE entry (if there is one.)
 
 2. Make sure the BACKUPMETHOD is:
  BACKUPMETHOD LEGACY
 
 
 Del
 
 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
 08:00:45 AM:
 
 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 08:01 AM
 Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor 
 Manager ADSM-L@vm.marist.edu
 
 Hi Remco!
 Has this changed than? We have been using the (older) TDP client for 
 multiple years but I never had to grant the BA client for TDP clients!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
 Behalf Of Remco Post
 Sent: woensdag 7 mei 2014 9:27
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error
 
 you need to grant proxy rights to the fs client for the sql client 
 (or
 
 vv) for VSS based backups to work, legacy backups work without such 
 proxy rights (and without the error message).
 
 Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- 
 van.l...@klm.com het volgende geschreven:
 
 Hi TSMers!
 Our SQL department is testing the TDP 6.4.1 client on their SQL
 Server 2012 servers. Backup and restore is working fine, but they 
 keep
 
 on receiving the following error:
 
 ANS1532E: Proxy Rejected: Proxy authority has not been granted to 
 this
 node
 
 Like I said, the restore works, but it's a bit annoying and I
 don't understand where it's coming from, we do not use a fromnode or 
 something...
 Thank you very much for your help in advance!
 Kind regards,
 Eric van Loon
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain 
 confidential and privileged material intended for the addressee only.
 If you are not the addressee, you are notified that no part of the 
 e-mail

Re: TDP for SQL server error

[Loon, EJ van (SPLXM) - KLM]

Hi Del!
I will ask our SQL department for their preferred solution.
Thank you VERY much for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: woensdag 7 mei 2014 17:07
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL server error

Hi Eric,

I agree. There is a fix for it and it is being tested now.
It is targeted for the 7.1.0.1 interim and will be available once the testing 
has completed.

If you decide you need an immediate fix, you can always open a PMR and ask for 
a patch.

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
10:39:00 AM:

 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 10:40 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 Ok... Hm... I don't think our SQL guys will be very charmed by the 
 work around (ignoring the error)... And I can't blame them. To my 
 opinion these kind of bugs should not be fixed in a new
 (maintenance) release but it should be fixed through an immediately 
 available fix release...
 However, thank you VERY much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL server error

[Remco Post]

you need to grant proxy rights to the fs client for the sql client (or vv) for 
VSS based backups to work, legacy backups work without such proxy rights (and 
without the error message).

Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM 
eric-van.l...@klm.com het volgende geschreven:

 Hi TSMers!
 Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 
 servers. Backup and restore is working fine, but they keep on receiving the 
 following error:
 
 ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node
 
 Like I said, the restore works, but it's a bit annoying and I don't 
 understand where it's coming from, we do not use a fromnode or something...
 Thank you very much for your help in advance!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 
 For information, services and offers, please visit our web site: 
 http://www.klm.com. This e-mail and any attachment may contain confidential 
 and privileged material intended for the addressee only. If you are not the 
 addressee, you are notified that no part of the e-mail or any attachment may 
 be disclosed, copied or distributed, and that any other action related to 
 this e-mail or attachment is strictly prohibited, and may be unlawful. If you 
 have received this e-mail by error, please notify the sender immediately by 
 return e-mail, and delete this message.
 
 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
 employees shall not be liable for the incorrect or incomplete transmission of 
 this e-mail or any attachments, nor responsible for any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
 Airlines) is registered in Amstelveen, The Netherlands, with registered 
 number 33014286
 

-- 

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: TDP for SQL server error

[Rick Harderwijk]

Eric,

Long shot: do you use the same node name for the SQL backup as for the
reguler OS backup? If not, maybe it detects the hostname of the machine but
the dsm.opt has a different (TDPSQL) node name so it thinks you are trying
to proxy?

Cheers,
Rick


On Wed, May 7, 2014 at 9:05 AM, Loon, EJ van (SPLXM) - KLM 
eric-van.l...@klm.com wrote:

 Hi TSMers!
 Our SQL department is testing the TDP 6.4.1 client on their SQL Server
 2012 servers. Backup and restore is working fine, but they keep on
 receiving the following error:

 ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node

 Like I said, the restore works, but it's a bit annoying and I don't
 understand where it's coming from, we do not use a fromnode or something...
 Thank you very much for your help in advance!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain
 confidential and privileged material intended for the addressee only. If
 you are not the addressee, you are notified that no part of the e-mail or
 any attachment may be disclosed, copied or distributed, and that any other
 action related to this e-mail or attachment is strictly prohibited, and may
 be unlawful. If you have received this e-mail by error, please notify the
 sender immediately by return e-mail, and delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
 employees shall not be liable for the incorrect or incomplete transmission
 of this e-mail or any attachments, nor responsible for any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
 Airlines) is registered in Amstelveen, The Netherlands, with registered
 number 33014286
 

Re: TDP for SQL server error

[Loon, EJ van (SPLXM) - KLM]

Hi Remco!
Has this changed than? We have been using the (older) TDP client for multiple 
years but I never had to grant the BA client for TDP clients!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco 
Post
Sent: woensdag 7 mei 2014 9:27
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL server error

you need to grant proxy rights to the fs client for the sql client (or vv) for 
VSS based backups to work, legacy backups work without such proxy rights (and 
without the error message).

Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM 
eric-van.l...@klm.com het volgende geschreven:

 Hi TSMers!
 Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 
 servers. Backup and restore is working fine, but they keep on receiving the 
 following error:
 
 ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node
 
 Like I said, the restore works, but it's a bit annoying and I don't 
 understand where it's coming from, we do not use a fromnode or something...
 Thank you very much for your help in advance!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 
 For information, services and offers, please visit our web site: 
 http://www.klm.com. This e-mail and any attachment may contain confidential 
 and privileged material intended for the addressee only. If you are not the 
 addressee, you are notified that no part of the e-mail or any attachment may 
 be disclosed, copied or distributed, and that any other action related to 
 this e-mail or attachment is strictly prohibited, and may be unlawful. If you 
 have received this e-mail by error, please notify the sender immediately by 
 return e-mail, and delete this message.
 
 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
 employees shall not be liable for the incorrect or incomplete transmission of 
 this e-mail or any attachments, nor responsible for any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
 Airlines) is registered in Amstelveen, The Netherlands, with registered 
 number 33014286
 

-- 

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL server error

[Loon, EJ van (SPLXM) - KLM]

Hi Rick!
No, we always use a different nodes for the BA client and the TDP client.
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick 
Harderwijk
Sent: woensdag 7 mei 2014 9:30
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL server error

Eric,

Long shot: do you use the same node name for the SQL backup as for the reguler 
OS backup? If not, maybe it detects the hostname of the machine but the dsm.opt 
has a different (TDPSQL) node name so it thinks you are trying to proxy?

Cheers,
Rick


On Wed, May 7, 2014 at 9:05 AM, Loon, EJ van (SPLXM) - KLM  
eric-van.l...@klm.com wrote:

 Hi TSMers!
 Our SQL department is testing the TDP 6.4.1 client on their SQL Server
 2012 servers. Backup and restore is working fine, but they keep on 
 receiving the following error:

 ANS1532E: Proxy Rejected: Proxy authority has not been granted to this 
 node

 Like I said, the restore works, but it's a bit annoying and I don't 
 understand where it's coming from, we do not use a fromnode or something...
 Thank you very much for your help in advance!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain 
 confidential and privileged material intended for the addressee only. 
 If you are not the addressee, you are notified that no part of the 
 e-mail or any attachment may be disclosed, copied or distributed, and 
 that any other action related to this e-mail or attachment is strictly 
 prohibited, and may be unlawful. If you have received this e-mail by 
 error, please notify the sender immediately by return e-mail, and delete this 
 message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or 
 its employees shall not be liable for the incorrect or incomplete 
 transmission of this e-mail or any attachments, nor responsible for any delay 
 in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
 Dutch
 Airlines) is registered in Amstelveen, The Netherlands, with 
 registered number 33014286
 


For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL server error

[Del Hoobler]

Hi Eric,

No. You should just be able to use legacy style backups.
My guess is that the configuration wizard inadvertently
added some entries causing this.

Check the tdpsql.cfg file.

1. Remove the LOCALDSMAGENTNODE entry (if there is one.)

2. Make sure the BACKUPMETHOD is:
  BACKUPMETHOD LEGACY


Del


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
08:00:45 AM:

 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 08:01 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Remco!
 Has this changed than? We have been using the (older) TDP client for
 multiple years but I never had to grant the BA client for TDP clients!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
 Behalf Of Remco Post
 Sent: woensdag 7 mei 2014 9:27
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error

 you need to grant proxy rights to the fs client for the sql client
 (or vv) for VSS based backups to work, legacy backups work without
 such proxy rights (and without the error message).

 Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric-
 van.l...@klm.com het volgende geschreven:

  Hi TSMers!
  Our SQL department is testing the TDP 6.4.1 client on their SQL
 Server 2012 servers. Backup and restore is working fine, but they
 keep on receiving the following error:
 
  ANS1532E: Proxy Rejected: Proxy authority has not been granted to this
node
 
  Like I said, the restore works, but it's a bit annoying and I
 don't understand where it's coming from, we do not use a fromnode or
 something...
  Thank you very much for your help in advance!
  Kind regards,
  Eric van Loon

Re: TDP for SQL server error

[Loon, EJ van (SPLXM) - KLM]

Hi Del!
The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As soon as he 
removes this line and starts the TDP GUI the wizard starts with the message 
that the TDP client has not been configured. And when he configures it through 
the wizard the  LOCALDSMAGENTNODE line is added again... The backup method is 
set to legacy in the tdpsql.cfg
Thank you very much for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: woensdag 7 mei 2014 14:09
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL server error

Hi Eric,

No. You should just be able to use legacy style backups.
My guess is that the configuration wizard inadvertently added some entries 
causing this.

Check the tdpsql.cfg file.

1. Remove the LOCALDSMAGENTNODE entry (if there is one.)

2. Make sure the BACKUPMETHOD is:
  BACKUPMETHOD LEGACY


Del


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
08:00:45 AM:

 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 08:01 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Remco!
 Has this changed than? We have been using the (older) TDP client for 
 multiple years but I never had to grant the BA client for TDP clients!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Remco Post
 Sent: woensdag 7 mei 2014 9:27
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error

 you need to grant proxy rights to the fs client for the sql client (or 
 vv) for VSS based backups to work, legacy backups work without such 
 proxy rights (and without the error message).

 Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- 
 van.l...@klm.com het volgende geschreven:

  Hi TSMers!
  Our SQL department is testing the TDP 6.4.1 client on their SQL
 Server 2012 servers. Backup and restore is working fine, but they keep 
 on receiving the following error:
 
  ANS1532E: Proxy Rejected: Proxy authority has not been granted to 
  this
node
 
  Like I said, the restore works, but it's a bit annoying and I
 don't understand where it's coming from, we do not use a fromnode or 
 something...
  Thank you very much for your help in advance!
  Kind regards,
  Eric van Loon

For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL server error

[Del Hoobler]

Hi Eric,

Yes... this is APAR IC99653.

   http://www-01.ibm.com/support/docview.wss?uid=swg1IC99653

For now, you can remove the LOCALDSMAGENTNODE option and
ignore the red X saying it isn't configured.

You can still perform the legacy backup operations.


Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
09:40:57 AM:

 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 09:41 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As
 soon as he removes this line and starts the TDP GUI the wizard
 starts with the message that the TDP client has not been configured.
 And when he configures it through the wizard the  LOCALDSMAGENTNODE
 line is added again... The backup method is set to legacy in the
tdpsql.cfg
 Thank you very much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
 Behalf Of Del Hoobler
 Sent: woensdag 7 mei 2014 14:09
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error

 Hi Eric,

 No. You should just be able to use legacy style backups.
 My guess is that the configuration wizard inadvertently added some
 entries causing this.

 Check the tdpsql.cfg file.

 1. Remove the LOCALDSMAGENTNODE entry (if there is one.)

 2. Make sure the BACKUPMETHOD is:
   BACKUPMETHOD LEGACY


 Del

 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
 08:00:45 AM:

  From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 05/07/2014 08:01 AM
  Subject: Re: TDP for SQL server error
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Remco!
  Has this changed than? We have been using the (older) TDP client for
  multiple years but I never had to grant the BA client for TDP clients!
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
  Of Remco Post
  Sent: woensdag 7 mei 2014 9:27
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL server error
 
  you need to grant proxy rights to the fs client for the sql client (or

  vv) for VSS based backups to work, legacy backups work without such
  proxy rights (and without the error message).
 
  Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric-
  van.l...@klm.com het volgende geschreven:
 
   Hi TSMers!
   Our SQL department is testing the TDP 6.4.1 client on their SQL
  Server 2012 servers. Backup and restore is working fine, but they keep

  on receiving the following error:
  
   ANS1532E: Proxy Rejected: Proxy authority has not been granted to
   this
 node
  
   Like I said, the restore works, but it's a bit annoying and I
  don't understand where it's coming from, we do not use a fromnode or
  something...
   Thank you very much for your help in advance!
   Kind regards,
   Eric van Loon
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain
 confidential and privileged material intended for the addressee
 only. If you are not the addressee, you are notified that no part of
 the e-mail or any attachment may be disclosed, copied or
 distributed, and that any other action related to this e-mail or
 attachment is strictly prohibited, and may be unlawful. If you have
 received this e-mail by error, please notify the sender immediately
 by return e-mail, and delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/
 or its employees shall not be liable for the incorrect or incomplete
 transmission of this e-mail or any attachments, nor responsible for
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
 Dutch Airlines) is registered in Amstelveen, The Netherlands, with
 registered number 33014286
 

Re: TDP for SQL server error

[Loon, EJ van (SPLXM) - KLM]

Hi Del!
Ok... Hm... I don't think our SQL guys will be very charmed by the work around 
(ignoring the error)... And I can't blame them. To my opinion these kind of 
bugs should not be fixed in a new (maintenance) release but it should be fixed 
through an immediately available fix release...
However, thank you VERY much for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: woensdag 7 mei 2014 16:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL server error

Hi Eric,

Yes... this is APAR IC99653.

   http://www-01.ibm.com/support/docview.wss?uid=swg1IC99653

For now, you can remove the LOCALDSMAGENTNODE option and ignore the red X 
saying it isn't configured.

You can still perform the legacy backup operations.


Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
09:40:57 AM:

 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 09:41 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As 
 soon as he removes this line and starts the TDP GUI the wizard starts 
 with the message that the TDP client has not been configured.
 And when he configures it through the wizard the  LOCALDSMAGENTNODE 
 line is added again... The backup method is set to legacy in the
tdpsql.cfg
 Thank you very much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: woensdag 7 mei 2014 14:09
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error

 Hi Eric,

 No. You should just be able to use legacy style backups.
 My guess is that the configuration wizard inadvertently added some 
 entries causing this.

 Check the tdpsql.cfg file.

 1. Remove the LOCALDSMAGENTNODE entry (if there is one.)

 2. Make sure the BACKUPMETHOD is:
   BACKUPMETHOD LEGACY


 Del

 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
 08:00:45 AM:

  From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 05/07/2014 08:01 AM
  Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor 
  Manager ADSM-L@vm.marist.edu
 
  Hi Remco!
  Has this changed than? We have been using the (older) TDP client for 
  multiple years but I never had to grant the BA client for TDP clients!
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
  Behalf Of Remco Post
  Sent: woensdag 7 mei 2014 9:27
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL server error
 
  you need to grant proxy rights to the fs client for the sql client 
  (or

  vv) for VSS based backups to work, legacy backups work without such 
  proxy rights (and without the error message).
 
  Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- 
  van.l...@klm.com het volgende geschreven:
 
   Hi TSMers!
   Our SQL department is testing the TDP 6.4.1 client on their SQL
  Server 2012 servers. Backup and restore is working fine, but they 
  keep

  on receiving the following error:
  
   ANS1532E: Proxy Rejected: Proxy authority has not been granted to 
   this
 node
  
   Like I said, the restore works, but it's a bit annoying and I
  don't understand where it's coming from, we do not use a fromnode or 
  something...
   Thank you very much for your help in advance!
   Kind regards,
   Eric van Loon
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain 
 confidential and privileged material intended for the addressee only. 
 If you are not the addressee, you are notified that no part of the 
 e-mail or any attachment may be disclosed, copied or distributed, and 
 that any other action related to this e-mail or attachment is strictly 
 prohibited, and may be unlawful. If you have received this e-mail by 
 error, please notify the sender immediately by return e-mail, and 
 delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or 
 its employees shall not be liable for the incorrect or incomplete 
 transmission of this e-mail or any attachments, nor responsible for 
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
 Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
 registered number 33014286
 



For information, services

Re: TDP for SQL server error

[Del Hoobler]

Hi Eric,

I agree. There is a fix for it and it is being tested now.
It is targeted for the 7.1.0.1 interim and will be available
once the testing has completed.

If you decide you need an immediate fix, you can always open
a PMR and ask for a patch.

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
10:39:00 AM:

 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 10:40 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 Ok... Hm... I don't think our SQL guys will be very charmed by the
 work around (ignoring the error)... And I can't blame them. To my
 opinion these kind of bugs should not be fixed in a new
 (maintenance) release but it should be fixed through an immediately
 available fix release...
 However, thank you VERY much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

Re: TDP for SQL server error

[Remco Post]

Op 7 mei 2014, om 16:39 heeft Loon, EJ van (SPLXM) - KLM 
eric-van.l...@klm.com het volgende geschreven:

 Hi Del!
 Ok... Hm... I don't think our SQL guys will be very charmed by the work 
 around (ignoring the error)...

not ignore the error, ignore a mistake in an icon... Don't make things bigger 
than they are :)


 And I can't blame them. To my opinion these kind of bugs should not be fixed 
 in a new (maintenance) release but it should be fixed through an immediately 
 available fix release...
 However, thank you VERY much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
 Hoobler
 Sent: woensdag 7 mei 2014 16:21
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error
 
 Hi Eric,
 
 Yes... this is APAR IC99653.
 
   http://www-01.ibm.com/support/docview.wss?uid=swg1IC99653
 
 For now, you can remove the LOCALDSMAGENTNODE option and ignore the red X 
 saying it isn't configured.
 
 You can still perform the legacy backup operations.
 
 
 Del
 
 
 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
 09:40:57 AM:
 
 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 09:41 AM
 Subject: Re: TDP for SQL server error
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
 Hi Del!
 The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As 
 soon as he removes this line and starts the TDP GUI the wizard starts 
 with the message that the TDP client has not been configured.
 And when he configures it through the wizard the  LOCALDSMAGENTNODE 
 line is added again... The backup method is set to legacy in the
 tdpsql.cfg
 Thank you very much for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: woensdag 7 mei 2014 14:09
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error
 
 Hi Eric,
 
 No. You should just be able to use legacy style backups.
 My guess is that the configuration wizard inadvertently added some 
 entries causing this.
 
 Check the tdpsql.cfg file.
 
 1. Remove the LOCALDSMAGENTNODE entry (if there is one.)
 
 2. Make sure the BACKUPMETHOD is:
  BACKUPMETHOD LEGACY
 
 
 Del
 
 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014
 08:00:45 AM:
 
 From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 05/07/2014 08:01 AM
 Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor 
 Manager ADSM-L@vm.marist.edu
 
 Hi Remco!
 Has this changed than? We have been using the (older) TDP client for 
 multiple years but I never had to grant the BA client for TDP clients!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
 Behalf Of Remco Post
 Sent: woensdag 7 mei 2014 9:27
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL server error
 
 you need to grant proxy rights to the fs client for the sql client 
 (or
 
 vv) for VSS based backups to work, legacy backups work without such 
 proxy rights (and without the error message).
 
 Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- 
 van.l...@klm.com het volgende geschreven:
 
 Hi TSMers!
 Our SQL department is testing the TDP 6.4.1 client on their SQL
 Server 2012 servers. Backup and restore is working fine, but they 
 keep
 
 on receiving the following error:
 
 ANS1532E: Proxy Rejected: Proxy authority has not been granted to 
 this
 node
 
 Like I said, the restore works, but it's a bit annoying and I
 don't understand where it's coming from, we do not use a fromnode or 
 something...
 Thank you very much for your help in advance!
 Kind regards,
 Eric van Loon
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain 
 confidential and privileged material intended for the addressee only. 
 If you are not the addressee, you are notified that no part of the 
 e-mail or any attachment may be disclosed, copied or distributed, and 
 that any other action related to this e-mail or attachment is strictly 
 prohibited, and may be unlawful. If you have received this e-mail by 
 error, please notify the sender immediately by return e-mail, and 
 delete this message.
 
 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or 
 its employees shall not be liable for the incorrect or incomplete 
 transmission of this e-mail or any attachments, nor responsible for 
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
 Dutch Airlines) is registered

Re: TDP for SQL

[David Bronder]

On 04/18/2014 09:08 PM, Saravanan wrote:
 While querying backups(active, inactive) during restore in version TDP SQL 
 6.4, its taking much time, some time more than 5 hours. Is there any 
 parameters can set in .cfg or .opt file to get faster response? Like TOC in 
 NAS

You didn't provide any detail about your environment.

In earlier versions of the TDP for SQL, at least, the SQL Server had to
restore the backup metadata objects to query backups because it didn't keep
local or centralized copies of that data the way Oracle does (with control
files or a RMAN catalog database).  So best practice is to keep all TDP SQL
metadata backups on fast-access storage pools (DISK, FILE or VTL) so there is
no appreciable delay (from tape mounts or seeks) in restoring the metadata
objects.

The TDP for SQL documentation describes this and gives examples of how to
configure include statements to direct the metadata backups to a suitable
storage pool (which you have to set up first).

Hope this is useful.  If you're already configured this way, please provide
us more detail about your environment for us to offer further advice.

=Dave

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu

Re: TDP for SQL

[Prather, Wanda]

It's exactly like that.  You need to keep the metadata on disk.

In the TDP for SQL 6.4 book, search for the topic Metadata Considerations.

This may also help:
http://www-01.ibm.com/support/docview.wss?uid=swg27035973
 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Saravanan
Sent: Friday, April 18, 2014 10:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL

While querying backups(active, inactive) during restore in version TDP SQL 6.4, 
its taking much time, some time more than 5 hours. Is there any parameters can 
set in .cfg or .opt file to get faster response? Like TOC in NAS
 

By Sarav
+65-82284384

Re: TDP for SQL

[Francisco Parrilla]

could you explain how are you doing this ... more details please =)





2014-04-18 21:08 GMT-05:00 Saravanan evergreen.sa...@gmail.com:

 While querying backups(active, inactive) during restore in version TDP SQL
 6.4, its taking much time, some time more than 5 hours. Is there any
 parameters can set in .cfg or .opt file to get faster response? Like TOC in
 NAS


 By Sarav
 +65-82284384

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

[Francisco Parrilla]

You can do both backups by the TDP for databases, but only legacy backup
can be restored to another server, VSS backup just can be restored at the
same server. If you try to issue a restore you can recover the database
files but never put online in SQL instance.

Best Regards



2014-04-08 23:54 GMT-05:00 Dhammika Rathnayake1 dhrat...@lk.ibm.com:

 Hi Francisco Parrilla,

  Thank you for the information.

  version is 6.4.
  Is online Legacy backup is enough?

  Best regards,
  Dhammika



 From:   Francisco Parrilla francisco.parri...@gmail.com
 To: ADSM-L@vm.marist.edu,
 Date:   04/08/2014 09:41 PM
 Subject:Re: [ADSM-L] TDP for SQL Server - restoring Database to
 another
 server (VSS Backup)
 Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu



 Which version of TDP have you?
 To restore SQL backup to another node this must be type Legacy backup ,
 there are one restriction for VSS backup, this of kind of backup just can
 restoring at the same server on some versions of TDP for SQL

 Best regards



 2014-04-08 10:56 GMT-05:00 Dhammika Rathnayake1 dhrat...@lk.ibm.com:

  Hi,
 
  I have restored the sql database to another server. Production server
  backup type is VSS (Windows Volume Shadow Copy).
  Restoration has completed successfully. But I didn't see restored
 database
  on the new server.
 
  After investigate the incident I realized that with the restoration
  production database has been overwrite.
  I used Tivoli Flash Copy Manager to do this restoration.
 
  Could you please explain me the method to restore VSS backup.
 
  Thanks
  Dhammika
 

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

[Dhammika Rathnayake1]

Hi Francisco

 Thanks a lot

 Best Regards,
 Dhammika



From:   Francisco Parrilla francisco.parri...@gmail.com
To: ADSM-L@vm.marist.edu,
Date:   04/09/2014 08:25 PM
Subject:Re: [ADSM-L] TDP for SQL Server - restoring Database to another
server (VSS Backup)
Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu



You can do both backups by the TDP for databases, but only legacy backup
can be restored to another server, VSS backup just can be restored at the
same server. If you try to issue a restore you can recover the database
files but never put online in SQL instance.

Best Regards



2014-04-08 23:54 GMT-05:00 Dhammika Rathnayake1 dhrat...@lk.ibm.com:

 Hi Francisco Parrilla,

  Thank you for the information.

  version is 6.4.
  Is online Legacy backup is enough?

  Best regards,
  Dhammika



 From:   Francisco Parrilla francisco.parri...@gmail.com
 To: ADSM-L@vm.marist.edu,
 Date:   04/08/2014 09:41 PM
 Subject:Re: [ADSM-L] TDP for SQL Server - restoring Database to
 another
 server (VSS Backup)
 Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu



 Which version of TDP have you?
 To restore SQL backup to another node this must be type Legacy backup ,
 there are one restriction for VSS backup, this of kind of backup just can
 restoring at the same server on some versions of TDP for SQL

 Best regards



 2014-04-08 10:56 GMT-05:00 Dhammika Rathnayake1 dhrat...@lk.ibm.com:

  Hi,
 
  I have restored the sql database to another server. Production server
  backup type is VSS (Windows Volume Shadow Copy).
  Restoration has completed successfully. But I didn't see restored
 database
  on the new server.
 
  After investigate the incident I realized that with the restoration
  production database has been overwrite.
  I used Tivoli Flash Copy Manager to do this restoration.
 
  Could you please explain me the method to restore VSS backup.
 
  Thanks
  Dhammika
 

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

[Francisco Parrilla]

Which version of TDP have you?
To restore SQL backup to another node this must be type Legacy backup ,
there are one restriction for VSS backup, this of kind of backup just can
restoring at the same server on some versions of TDP for SQL

Best regards



2014-04-08 10:56 GMT-05:00 Dhammika Rathnayake1 dhrat...@lk.ibm.com:

 Hi,

 I have restored the sql database to another server. Production server
 backup type is VSS (Windows Volume Shadow Copy).
 Restoration has completed successfully. But I didn't see restored database
 on the new server.

 After investigate the incident I realized that with the restoration
 production database has been overwrite.
 I used Tivoli Flash Copy Manager to do this restoration.

 Could you please explain me the method to restore VSS backup.

 Thanks
 Dhammika

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

[Del Hoobler]

Microsoft does not support restoring VSS backups
into a SQL Server that has a different name.

This is a Microsoft restriction and is
documented in the Data Protection for SQL User's Guide.

Thank you,

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 04/08/2014
11:56:22 AM:

 From: Dhammika Rathnayake1 dhrat...@lk.ibm.com
 To: ADSM-L@vm.marist.edu,
 Date: 04/08/2014 11:59 AM
 Subject: TDP for SQL Server - restoring Database to another server
 (VSS Backup)
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi,

 I have restored the sql database to another server. Production server
 backup type is VSS (Windows Volume Shadow Copy).
 Restoration has completed successfully. But I didn't see restored
database
 on the new server.

 After investigate the incident I realized that with the restoration
 production database has been overwrite.
 I used Tivoli Flash Copy Manager to do this restoration.

 Could you please explain me the method to restore VSS backup.

 Thanks
 Dhammika

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

[Dhammika Rathnayake1]

Hi Francisco Parrilla,

 Thank you for the information.

 version is 6.4.
 Is online Legacy backup is enough?

 Best regards,
 Dhammika



From:   Francisco Parrilla francisco.parri...@gmail.com
To: ADSM-L@vm.marist.edu,
Date:   04/08/2014 09:41 PM
Subject:Re: [ADSM-L] TDP for SQL Server - restoring Database to another
server (VSS Backup)
Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu



Which version of TDP have you?
To restore SQL backup to another node this must be type Legacy backup ,
there are one restriction for VSS backup, this of kind of backup just can
restoring at the same server on some versions of TDP for SQL

Best regards



2014-04-08 10:56 GMT-05:00 Dhammika Rathnayake1 dhrat...@lk.ibm.com:

 Hi,

 I have restored the sql database to another server. Production server
 backup type is VSS (Windows Volume Shadow Copy).
 Restoration has completed successfully. But I didn't see restored
database
 on the new server.

 After investigate the incident I realized that with the restoration
 production database has been overwrite.
 I used Tivoli Flash Copy Manager to do this restoration.

 Could you please explain me the method to restore VSS backup.

 Thanks
 Dhammika

Re: TDP for SQL 6.4.1 cross-server restore setup

[Schaub, Steve]

Thanks, Del.
As Steven H noted, someone really needs to impress on the developers that 
putting out a product that requires customers to made ad hoc changes to their 
production config files on the fly is really not enterprise quality engineering.
-steve s

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: Thursday, February 13, 2014 12:59 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL 6.4.1 cross-server restore setup

Hello,

I am sorry for problems this has caused.

A fix for this is targeted for the DP/SQL 7.1.0.1 iFix.
Current estimate is April.

Thank you.


Del

-


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/13/2014
11:53:25 AM:

 From: Hans Christian Riksheim bull...@gmail.com
 To: ADSM-L@vm.marist.edu,
 Date: 02/13/2014 11:54 AM
 Subject: Re: TDP for SQL 6.4.1 cross-server restore setup Sent by: 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 I agree.

 With the old GUI I put a link in the Public Desktop-folder for each
MSSQL
 instance. Easy for the MSSQL-people just to double click on a named 
 icon
on
 their desktop which pointed to the correct configfile.

 Now they are copying cfg-files all around in the tdpsql directory. On
one
 occation a configfile for an instance was emptied in this process. The 
 backup schedule had no problem with that since it just backed up the 
 default instance instead. So not only an inconvenience but also an 
 added risk with the new GUI. I vote for a speedy resolve of this 
 future improvement.

 Hans Chr.




 On Thu, Feb 13, 2014 at 12:11 PM, Steven Harris
 st...@stevenharris.infowrote:

  Thanks for the workaround Del,  this is not directed at you.
 
  Surely this would have come up and been solved in any reasonable 
  beta test program, well before being inflicted on long-suffering customers?
  Sometimes I wonder if any consideration is given to those who use 
  the product day to day.  The idiotic work arounds that we have to 
  use,
that
  have been in the TSM for years and continue to cause wasted time and 
  effort by everyone flabbergast me.  One of my accounts has just gone
off
  to something that promises a brand new approach.  Time will tell if
the
  reality matches the glossies, but this is exactly the sort of reason
why
  they leave.
 
  Spleen vented, submerging again,
  Steve
 
  Steven Harris
  TSM Admin
  Canberra Australia
 
 
 
  On 13/02/2014 5:04 AM, Del Hoobler wrote:
 
  Hi Steve,
 
  See if this helps:
 
   http://www-01.ibm.com/support/docview.wss?uid=swg21597023
 
  BTW... this is a known requirement. There are plans to add this 
  function directly to the launch of the MMC soon.
 
 
  Thank you,
 
  Del
 
  
 
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 
  02/12/2014
  11:46:58 AM:
 
   From: Schaub, Steve steve_sch...@bcbst.com
  To: ADSM-L@vm.marist.edu,
  Date: 02/12/2014 12:36 PM
  Subject: TDP for SQL 6.4.1 cross-server restore setup Sent by: 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Windows 2012, TSM  TDP 6.4.1
 
  Our DBA's do a fair amount of cross-server restores here.  Since I 
  cant depend on them editing the dsm.opt file (tried that before, 
  ended up with a bunch of backups in the wrong place because they 
  forgot to change it back), I came up with a little pre-launch 
  script that allows them to pick a SQL node from our inventory to 
  restore from, then builds a temp opt file using that node name, 
  and launches the tdp gui using that opt file.
 
  However, now that 6.4.1 has killed off the tdp gui in favor of the 
  mmc, I haven't been able to figure out how to achieve the same 
  results.  Can someone tell me how to launch the mmc using an 
  alternate opt file?
 
 

-
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL 6.4.1 cross-server restore setup

[Rick Adamson]

Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: biloholdings.com
X-Barracuda-Connect: 
mail-by2lp0239.outbound.protection.outlook.com[207.46.163.239]
X-Barracuda-Start-Time: 1392383883
X-Barracuda-Encrypted: AES128-SHA
X-Barracuda-URL: http://148.100.49.28:8000/cgi-mod/mark.cgi
X-Virus-Scanned: by bsmtpd at marist.edu
X-Barracuda-BRTS-Status: 1
X-Barracuda-Spam-Score: 0.00
X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=3.5 
QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.5 tests=INFO_TLD
X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.145106
Rule breakdown below
 pts rule name  description
 -- 
--
0.00 INFO_TLD   URI: Contains an URL in the INFO top-level 
domain

Yup, this is one of my DBA team's biggest complaints regarding TSM.

-Rick Adamson
904.783.5264


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Sc=
haub, Steve
Sent: Friday, February 14, 2014 7:06 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL 6.4.1 cross-server restore setup

Thanks, Del.
As Steven H noted, someone really needs to impress on the developers that p=
utting out a product that requires customers to made ad hoc changes to thei=
r production config files on the fly is really not enterprise quality engin=
eering.
-steve s

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of De=
l Hoobler
Sent: Thursday, February 13, 2014 12:59 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL 6.4.1 cross-server restore setup

Hello,

I am sorry for problems this has caused.

A fix for this is targeted for the DP/SQL 7.1.0.1 iFix.
Current estimate is April.

Thank you.


Del

-


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/13/2014
11:53:25 AM:

 From: Hans Christian Riksheim bull...@gmail.com
 To: ADSM-L@vm.marist.edu,
 Date: 02/13/2014 11:54 AM
 Subject: Re: TDP for SQL 6.4.1 cross-server restore setup Sent by:=20
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 I agree.

 With the old GUI I put a link in the Public Desktop-folder for each
MSSQL
 instance. Easy for the MSSQL-people just to double click on a named=20
 icon
on
 their desktop which pointed to the correct configfile.

 Now they are copying cfg-files all around in the tdpsql directory. On
one
 occation a configfile for an instance was emptied in this process. The=20
 backup schedule had no problem with that since it just backed up the=20
 default instance instead. So not only an inconvenience but also an=20
 added risk with the new GUI. I vote for a speedy resolve of this=20
 future improvement.

 Hans Chr.




 On Thu, Feb 13, 2014 at 12:11 PM, Steven Harris
 st...@stevenharris.infowrote:

  Thanks for the workaround Del,  this is not directed at you.
 
  Surely this would have come up and been solved in any reasonable=20
  beta test program, well before being inflicted on long-suffering custom=
ers?
  Sometimes I wonder if any consideration is given to those who use=20
  the product day to day.  The idiotic work arounds that we have to=20
  use,
that
  have been in the TSM for years and continue to cause wasted time and=20
  effort by everyone flabbergast me.  One of my accounts has just gone
off
  to something that promises a brand new approach.  Time will tell if
the
  reality matches the glossies, but this is exactly the sort of reason
why
  they leave.
 
  Spleen vented, submerging again,
  Steve
 
  Steven Harris
  TSM Admin
  Canberra Australia
 
 
 
  On 13/02/2014 5:04 AM, Del Hoobler wrote:
 
  Hi Steve,
 
  See if this helps:
 
   http://www-01.ibm.com/support/docview.wss?uid=3Dswg21597023
 
  BTW... this is a known requirement. There are plans to add this=20
  function directly to the launch of the MMC soon.
 
 
  Thank you,
 
  Del
 
  
 
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on
  02/12/2014
  11:46:58 AM:
 
   From: Schaub, Steve steve_sch...@bcbst.com
  To: ADSM-L@vm.marist.edu,
  Date: 02/12/2014 12:36 PM
  Subject: TDP for SQL 6.4.1 cross-server restore setup Sent by:=20
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Windows 2012, TSM  TDP 6.4.1
 
  Our DBA's do a fair amount of cross-server restores here.  Since I=20
  cant depend on them editing the dsm.opt file (tried that before,=20
  ended up with a bunch of backups in the wrong place because they=20
  forgot to change it back), I came up with a little pre-launch=20
  script that allows them to pick a SQL node from our inventory to=20
  restore from, then builds a temp opt file using that node name,=20
  and launches the tdp gui using that opt file.
 
  However, now that 6.4.1 has killed off the tdp gui in favor of the=20
  mmc, I haven't

Re: TDP for SQL 6.4.1 cross-server restore setup

[Del Hoobler]

Point well taken and thank you. As soon as I saw this on Wednesday,
I shared it with the rest of the team.

As I noted earlier, we will have a fix for this targeted
for April in DP/SQL 7.1.0.1.

I will take this opportunity to mention that we do have
a TSM/FCM EAP/beta program running for the next release and
would love to have anyone interested. If you are interested
in enrolling, please submit a sign-up form here:


https://www-304.ibm.com/software/support/trial/cst/forms/nomination.wss?id=5311


For any questions, please contact Mary Anne Filosa, mfil...@us.ibm.com


Thank you,

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/14/2014
07:06:29 AM:

 From: Schaub, Steve steve_sch...@bcbst.com
 To: ADSM-L@vm.marist.edu,
 Date: 02/14/2014 07:07 AM
 Subject: Re: TDP for SQL 6.4.1 cross-server restore setup
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Thanks, Del.
 As Steven H noted, someone really needs to impress on the developers
 that putting out a product that requires customers to made ad hoc
 changes to their production config files on the fly is really not
 enterprise quality engineering.
 -steve s

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
 Behalf Of Del Hoobler
 Sent: Thursday, February 13, 2014 12:59 PM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] TDP for SQL 6.4.1 cross-server restore setup

 Hello,

 I am sorry for problems this has caused.

 A fix for this is targeted for the DP/SQL 7.1.0.1 iFix.
 Current estimate is April.

 Thank you.


 Del

 -


 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/13/2014
 11:53:25 AM:

  From: Hans Christian Riksheim bull...@gmail.com
  To: ADSM-L@vm.marist.edu,
  Date: 02/13/2014 11:54 AM
  Subject: Re: TDP for SQL 6.4.1 cross-server restore setup Sent by:
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  I agree.
 
  With the old GUI I put a link in the Public Desktop-folder for each
 MSSQL
  instance. Easy for the MSSQL-people just to double click on a named
  icon
 on
  their desktop which pointed to the correct configfile.
 
  Now they are copying cfg-files all around in the tdpsql directory. On
 one
  occation a configfile for an instance was emptied in this process. The

  backup schedule had no problem with that since it just backed up the
  default instance instead. So not only an inconvenience but also an
  added risk with the new GUI. I vote for a speedy resolve of this
  future improvement.
 
  Hans Chr.
 
 
 
 
  On Thu, Feb 13, 2014 at 12:11 PM, Steven Harris
  st...@stevenharris.infowrote:
 
   Thanks for the workaround Del,  this is not directed at you.
  
   Surely this would have come up and been solved in any reasonable
   beta test program, well before being inflicted on
long-sufferingcustomers?
   Sometimes I wonder if any consideration is given to those who use
   the product day to day.  The idiotic work arounds that we have to
   use,
 that
   have been in the TSM for years and continue to cause wasted time and

   effort by everyone flabbergast me.  One of my accounts has just gone
 off
   to something that promises a brand new approach.  Time will tell if
 the
   reality matches the glossies, but this is exactly the sort of reason
 why
   they leave.
  
   Spleen vented, submerging again,
   Steve
  
   Steven Harris
   TSM Admin
   Canberra Australia
  
  
  
   On 13/02/2014 5:04 AM, Del Hoobler wrote:
  
   Hi Steve,
  
   See if this helps:
  
http://www-01.ibm.com/support/docview.wss?uid=swg21597023
  
   BTW... this is a known requirement. There are plans to add this
   function directly to the launch of the MMC soon.
  
  
   Thank you,
  
   Del
  
   
  
  
   ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on
   02/12/2014
   11:46:58 AM:
  
From: Schaub, Steve steve_sch...@bcbst.com
   To: ADSM-L@vm.marist.edu,
   Date: 02/12/2014 12:36 PM
   Subject: TDP for SQL 6.4.1 cross-server restore setup Sent by:
   ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
  
   Windows 2012, TSM  TDP 6.4.1
  
   Our DBA's do a fair amount of cross-server restores here.  Since I

   cant depend on them editing the dsm.opt file (tried that before,
   ended up with a bunch of backups in the wrong place because they
   forgot to change it back), I came up with a little pre-launch
   script that allows them to pick a SQL node from our inventory to
   restore from, then builds a temp opt file using that node name,
   and launches the tdp gui using that opt file.
  
   However, now that 6.4.1 has killed off the tdp gui in favor of the

   mmc, I haven't been able to figure out how to achieve the same
   results.  Can someone tell me how to launch the mmc using an
   alternate opt file?
  
  
 
 -
 Please see the following link for the BlueCross BlueShield

Re: TDP for SQL 6.4.1 cross-server restore setup

[Steven Harris]

Thanks for the workaround Del,  this is not directed at you.

Surely this would have come up and been solved in any reasonable beta
test program, well before being inflicted on long-suffering customers?
Sometimes I wonder if any consideration is given to those who use the
product day to day.  The idiotic work arounds that we have to use, that
have been in the TSM for years and continue to cause wasted time and
effort by everyone flabbergast me.  One of my accounts has just gone off
to something that promises a brand new approach.  Time will tell if the
reality matches the glossies, but this is exactly the sort of reason why
they leave.

Spleen vented, submerging again,
Steve

Steven Harris
TSM Admin
Canberra Australia


On 13/02/2014 5:04 AM, Del Hoobler wrote:

Hi Steve,

See if this helps:

 http://www-01.ibm.com/support/docview.wss?uid=swg21597023

BTW... this is a known requirement. There are plans to add
this function directly to the launch of the MMC soon.


Thank you,

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/12/2014
11:46:58 AM:


From: Schaub, Steve steve_sch...@bcbst.com
To: ADSM-L@vm.marist.edu,
Date: 02/12/2014 12:36 PM
Subject: TDP for SQL 6.4.1 cross-server restore setup
Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

Windows 2012, TSM  TDP 6.4.1

Our DBA's do a fair amount of cross-server restores here.  Since I
cant depend on them editing the dsm.opt file (tried that before,
ended up with a bunch of backups in the wrong place because they
forgot to change it back), I came up with a little pre-launch script
that allows them to pick a SQL node from our inventory to restore
from, then builds a temp opt file using that node name, and launches
the tdp gui using that opt file.

However, now that 6.4.1 has killed off the tdp gui in favor of the
mmc, I haven't been able to figure out how to achieve the same
results.  Can someone tell me how to launch the mmc using an
alternate opt file?

Re: TDP for SQL 6.4.1 cross-server restore setup

[Del Hoobler]

Hello,

I am sorry for problems this has caused.

A fix for this is targeted for the DP/SQL 7.1.0.1 iFix.
Current estimate is April.

Thank you.


Del

-


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/13/2014
11:53:25 AM:

 From: Hans Christian Riksheim bull...@gmail.com
 To: ADSM-L@vm.marist.edu,
 Date: 02/13/2014 11:54 AM
 Subject: Re: TDP for SQL 6.4.1 cross-server restore setup
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 I agree.

 With the old GUI I put a link in the Public Desktop-folder for each
MSSQL
 instance. Easy for the MSSQL-people just to double click on a named icon
on
 their desktop which pointed to the correct configfile.

 Now they are copying cfg-files all around in the tdpsql directory. On
one
 occation a configfile for an instance was emptied in this process. The
 backup schedule had no problem with that since it just backed up the
 default instance instead. So not only an inconvenience but also an added
 risk with the new GUI. I vote for a speedy resolve of this future
 improvement.

 Hans Chr.




 On Thu, Feb 13, 2014 at 12:11 PM, Steven Harris
 st...@stevenharris.infowrote:

  Thanks for the workaround Del,  this is not directed at you.
 
  Surely this would have come up and been solved in any reasonable beta
  test program, well before being inflicted on long-suffering customers?
  Sometimes I wonder if any consideration is given to those who use the
  product day to day.  The idiotic work arounds that we have to use,
that
  have been in the TSM for years and continue to cause wasted time and
  effort by everyone flabbergast me.  One of my accounts has just gone
off
  to something that promises a brand new approach.  Time will tell if
the
  reality matches the glossies, but this is exactly the sort of reason
why
  they leave.
 
  Spleen vented, submerging again,
  Steve
 
  Steven Harris
  TSM Admin
  Canberra Australia
 
 
 
  On 13/02/2014 5:04 AM, Del Hoobler wrote:
 
  Hi Steve,
 
  See if this helps:
 
   http://www-01.ibm.com/support/docview.wss?uid=swg21597023
 
  BTW... this is a known requirement. There are plans to add
  this function directly to the launch of the MMC soon.
 
 
  Thank you,
 
  Del
 
  
 
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/12/2014
  11:46:58 AM:
 
   From: Schaub, Steve steve_sch...@bcbst.com
  To: ADSM-L@vm.marist.edu,
  Date: 02/12/2014 12:36 PM
  Subject: TDP for SQL 6.4.1 cross-server restore setup
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Windows 2012, TSM  TDP 6.4.1
 
  Our DBA's do a fair amount of cross-server restores here.  Since I
  cant depend on them editing the dsm.opt file (tried that before,
  ended up with a bunch of backups in the wrong place because they
  forgot to change it back), I came up with a little pre-launch script
  that allows them to pick a SQL node from our inventory to restore
  from, then builds a temp opt file using that node name, and launches
  the tdp gui using that opt file.
 
  However, now that 6.4.1 has killed off the tdp gui in favor of the
  mmc, I haven't been able to figure out how to achieve the same
  results.  Can someone tell me how to launch the mmc using an
  alternate opt file?
 
 

Re: TDP for SQL 6.4.1 cross-server restore setup

[Del Hoobler]

Hi Steve,

See if this helps:

http://www-01.ibm.com/support/docview.wss?uid=swg21597023

BTW... this is a known requirement. There are plans to add
this function directly to the launch of the MMC soon.


Thank you,

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/12/2014
11:46:58 AM:

 From: Schaub, Steve steve_sch...@bcbst.com
 To: ADSM-L@vm.marist.edu,
 Date: 02/12/2014 12:36 PM
 Subject: TDP for SQL 6.4.1 cross-server restore setup
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Windows 2012, TSM  TDP 6.4.1

 Our DBA's do a fair amount of cross-server restores here.  Since I
 cant depend on them editing the dsm.opt file (tried that before,
 ended up with a bunch of backups in the wrong place because they
 forgot to change it back), I came up with a little pre-launch script
 that allows them to pick a SQL node from our inventory to restore
 from, then builds a temp opt file using that node name, and launches
 the tdp gui using that opt file.

 However, now that 6.4.1 has killed off the tdp gui in favor of the
 mmc, I haven't been able to figure out how to achieve the same
 results.  Can someone tell me how to launch the mmc using an
 alternate opt file?

Re: TDP for SQL 7.1

[Angela Robertson]

Hi Hans Chr.,

I apologize for any inconvenience or frustration that you experienced when
trying to locate the technical information that you need. Based on your
email, I suggest the following topic:

Considerations for using Data Protection for SQL Server in a Windows
Failover Cluster environment -
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fc_dpfcm_plan_sqlwsfc_sql.html


Other topics that might be useful:
Using Data Protection for SQL Server in a Windows Failover Cluster
environment -
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_mscs.html

Using Data Protection for SQL Server in a Veritas Cluster Server
environment -
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_vcs.html


If this information is not what you need, or, if you need additional
information, you can click the Feedback link, located at the bottom of
these pages. I receive the Feedback that you submit. We can work together
to update the doc. When we have the complete documentation available, I
will post a link to this group. Angela


Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014
07:52:59 AM:

 Hans Christian Riksheim bull...@gmail.com
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 01/14/2014 07:52 AM

 Please respond to
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 To

 ADSM-L@vm.marist.edu,

 cc

 Subject

 [ADSM-L] TDP for SQL 7.1

 Hi,

 can anyone be so kind to point me in the direction of the documentation
of
 this product. Trying to understand the basics of backing up a alwayson
 cluster and the information center is of little help.

 Thanks.

 Hans Chr.

Re: TDP for SQL 7.1

[Hans Christian Riksheim]

Thanks for the reply.

Backup of MSSQL with clustering and Alwayson is (for me at least) a complex
task and I really want to understand what is going on. Unfortunately the
info center only offers unorganiized snippets of information which does not
really help much.

For v5.5 I had a redbook which was really helpful. Does IBM have any
similar documentation for version 7.1 or 6.4?

Regards

Hans Chr.


On Tue, Jan 14, 2014 at 2:20 PM, Angela Robertson aprob...@us.ibm.comwrote:

 Hi Hans Chr.,

 I apologize for any inconvenience or frustration that you experienced when
 trying to locate the technical information that you need. Based on your
 email, I suggest the following topic:

 Considerations for using Data Protection for SQL Server in a Windows
 Failover Cluster environment -

 http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fc_dpfcm_plan_sqlwsfc_sql.html


 Other topics that might be useful:
 Using Data Protection for SQL Server in a Windows Failover Cluster
 environment -

 http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_mscs.html

 Using Data Protection for SQL Server in a Veritas Cluster Server
 environment -

 http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_vcs.html


 If this information is not what you need, or, if you need additional
 information, you can click the Feedback link, located at the bottom of
 these pages. I receive the Feedback that you submit. We can work together
 to update the doc. When we have the complete documentation available, I
 will post a link to this group. Angela

 
 Angela Robertson
 IBM Software Group
 Durham, NC 27703
 aprob...@us.ibm.com
 

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014
 07:52:59 AM:

  Hans Christian Riksheim bull...@gmail.com
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  01/14/2014 07:52 AM
 
  Please respond to
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  To
 
  ADSM-L@vm.marist.edu,
 
  cc
 
  Subject
 
  [ADSM-L] TDP for SQL 7.1
 
  Hi,
 
  can anyone be so kind to point me in the direction of the documentation
 of
  this product. Trying to understand the basics of backing up a alwayson
  cluster and the information center is of little help.
 
  Thanks.
 
  Hans Chr.
 

Re: TDP for SQL 7.1

[Angela Robertson]

Hi,

For the 4.1 / 7.1 release, we started to improve the technical content re:
configuring clustered environments. The content is published as part of the
FlashCopy Manager for Windows 4.1 update:

  Configure clustered environments -
  
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.fcm.win.doc%2Fr_fcm_configure_cluster.html



This topic includes information about how to set up a clustered environment
for Tivoli Storage FlashCopy Manager for SQL with a Tivoli Storage Manager
configuration. The detailed instructions have been used by multiple teams
and we've received positive feedback. If you find the information helpful
or lacking, I want to know so we can continue to improve. You can post to
this listserv or use the Feedback link on the page to submit feedback that
I can respond to in a timely manner.

I want to write similar instructions for the next update of the TDP for
SQL. In the meantime, I do not know of any plans to update the IBM Redbook
that you referenced (Backing up Microsoft SQL Server with IBM Tivoli
Storage Manager; http://publib-b.boulder.ibm.com/abstracts/sg246148.html).
If I find out that this publication is going to be updated, I can post an
update.

Angela

Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014
09:39:05 AM:

 Hans Christian Riksheim bull...@gmail.com
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 01/14/2014 09:39 AM

 Please respond to
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 To

 ADSM-L@vm.marist.edu,

 cc

 Subject

 Re: [ADSM-L] TDP for SQL 7.1

 Thanks for the reply.

 Backup of MSSQL with clustering and Alwayson is (for me at least) a
complex
 task and I really want to understand what is going on. Unfortunately the
 info center only offers unorganiized snippets of information which does
not
 really help much.

 For v5.5 I had a redbook which was really helpful. Does IBM have any
 similar documentation for version 7.1 or 6.4?

 Regards

 Hans Chr.


 On Tue, Jan 14, 2014 at 2:20 PM, Angela Robertson
aprob...@us.ibm.comwrote:

  Hi Hans Chr.,
 
  I apologize for any inconvenience or frustration that you experienced
when
  trying to locate the technical information that you need. Based on your
  email, I suggest the following topic:
 
  Considerations for using Data Protection for SQL Server in a Windows
  Failover Cluster environment -
 
  http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%
 2Fcom.ibm.itsm.db.sql.doc%2Fc_dpfcm_plan_sqlwsfc_sql.html
 
 
  Other topics that might be useful:
  Using Data Protection for SQL Server in a Windows Failover Cluster
  environment -
 
  http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%
 2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_mscs.html
 
  Using Data Protection for SQL Server in a Veritas Cluster Server
  environment -
 
  http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%
 2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_vcs.html
 
 
  If this information is not what you need, or, if you need additional
  information, you can click the Feedback link, located at the bottom of
  these pages. I receive the Feedback that you submit. We can work
together
  to update the doc. When we have the complete documentation available, I
  will post a link to this group. Angela
 
  
  Angela Robertson
  IBM Software Group
  Durham, NC 27703
  aprob...@us.ibm.com
  
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014
  07:52:59 AM:
 
   Hans Christian Riksheim bull...@gmail.com
   Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
  
   01/14/2014 07:52 AM
  
   Please respond to
   ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
  
   To
  
   ADSM-L@vm.marist.edu,
  
   cc
  
   Subject
  
   [ADSM-L] TDP for SQL 7.1
  
   Hi,
  
   can anyone be so kind to point me in the direction of the
documentation
  of
   this product. Trying to understand the basics of backing up a
alwayson
   cluster and the information center is of little help.
  
   Thanks.
  
   Hans Chr.
  
 

Re: TDP for SQL 7.1

[Hans Christian Riksheim]

Thanks.

I take it that the Redbook from 2008 is IBMs last effort to make a
comprehensible documentation on this product.

I will stick with the Information Center then.

Regards

Hans Chr.


On Tue, Jan 14, 2014 at 4:18 PM, Angela Robertson aprob...@us.ibm.comwrote:

 Hi,

 For the 4.1 / 7.1 release, we started to improve the technical content re:
 configuring clustered environments. The content is published as part of the
 FlashCopy Manager for Windows 4.1 update:

   Configure clustered environments -

 http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.fcm.win.doc%2Fr_fcm_configure_cluster.html



 This topic includes information about how to set up a clustered environment
 for Tivoli Storage FlashCopy Manager for SQL with a Tivoli Storage Manager
 configuration. The detailed instructions have been used by multiple teams
 and we've received positive feedback. If you find the information helpful
 or lacking, I want to know so we can continue to improve. You can post to
 this listserv or use the Feedback link on the page to submit feedback that
 I can respond to in a timely manner.

 I want to write similar instructions for the next update of the TDP for
 SQL. In the meantime, I do not know of any plans to update the IBM Redbook
 that you referenced (Backing up Microsoft SQL Server with IBM Tivoli
 Storage Manager; http://publib-b.boulder.ibm.com/abstracts/sg246148.html).
 If I find out that this publication is going to be updated, I can post an
 update.

 Angela
 
 Angela Robertson
 IBM Software Group
 Durham, NC 27703
 aprob...@us.ibm.com
 

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014
 09:39:05 AM:

  Hans Christian Riksheim bull...@gmail.com
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  01/14/2014 09:39 AM
 
  Please respond to
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  To
 
  ADSM-L@vm.marist.edu,
 
  cc
 
  Subject
 
  Re: [ADSM-L] TDP for SQL 7.1
 
  Thanks for the reply.
 
  Backup of MSSQL with clustering and Alwayson is (for me at least) a
 complex
  task and I really want to understand what is going on. Unfortunately the
  info center only offers unorganiized snippets of information which does
 not
  really help much.
 
  For v5.5 I had a redbook which was really helpful. Does IBM have any
  similar documentation for version 7.1 or 6.4?
 
  Regards
 
  Hans Chr.
 
 
  On Tue, Jan 14, 2014 at 2:20 PM, Angela Robertson
 aprob...@us.ibm.comwrote:
 
   Hi Hans Chr.,
  
   I apologize for any inconvenience or frustration that you experienced
 when
   trying to locate the technical information that you need. Based on your
   email, I suggest the following topic:
  
   Considerations for using Data Protection for SQL Server in a Windows
   Failover Cluster environment -
  
   http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%
  2Fcom.ibm.itsm.db.sql.doc%2Fc_dpfcm_plan_sqlwsfc_sql.html
  
  
   Other topics that might be useful:
   Using Data Protection for SQL Server in a Windows Failover Cluster
   environment -
  
   http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%
  2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_mscs.html
  
   Using Data Protection for SQL Server in a Veritas Cluster Server
   environment -
  
   http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%
  2Fcom.ibm.itsm.db.sql.doc%2Fdps_con_info_vcs.html
  
  
   If this information is not what you need, or, if you need additional
   information, you can click the Feedback link, located at the bottom of
   these pages. I receive the Feedback that you submit. We can work
 together
   to update the doc. When we have the complete documentation available, I
   will post a link to this group. Angela
  
   
   Angela Robertson
   IBM Software Group
   Durham, NC 27703
   aprob...@us.ibm.com
   
  
   ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014
   07:52:59 AM:
  
Hans Christian Riksheim bull...@gmail.com
Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
   
01/14/2014 07:52 AM
   
Please respond to
ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
   
To
   
ADSM-L@vm.marist.edu,
   
cc
   
Subject
   
[ADSM-L] TDP for SQL 7.1
   
Hi,
   
can anyone be so kind to point me in the direction of the
 documentation
   of
this product. Trying to understand the basics of backing up a
 alwayson
cluster and the information center is of little help.
   
Thanks.
   
Hans Chr.
   
  
 

Re: TDP for SQL Server

[Loon, EJ van - SPLXM]

Hi Del!
Our SQL guys did some testing with the new SQL client. When you install
6.4.0 and 6.4.1 afterwards the wizards starts fine.
In fact the following thing changed: In the early days we installed the
TDP client and copied the license file afterwards. This always worked,
but not anymore. When you copy the license file BEFORE installing the
TDP client, the wizard starts fine. So one first has to copy the license
file to C:\Program Files\Tivoli\TSM\TDPSql and then you can immediately
install the 6.4.1 client, which starts the wizard.
This is an acceptable work-around for the SQL guys, the only thing to
keep in mind is that part of the 6.4.1 client is the installation of the
.NET 4.5 framework which requires a reboot! Not very desirable in a
production environment, so this has to be carefully planned.
Anyway, thank you very much for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Del Hoobler
Sent: vrijdag 1 november 2013 15:58
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server

Hi Eric,

What happens if you install 6.4.0 first, then follow it with an upgrade
to 6.4.1?

The book is written to follow that method since it is the best practice
method to get the paid (base) license installed first, then follow it
with the PTF (fix) package.

This is slightly different than the BA client, since the BA client does
not have the requirement of the license file.


Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Software Group - Cloud  Smarter Infrastructure IBM Corporation



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
09:01:24 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 11/01/2013 09:03 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 I removed the 6.3 client and installed 6.4.1. This installer is also 
 not working according to the manual. Here's what I did:

 I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport 
 Advantage I extracted the sqlclient.lic from the 6.4.0 package I 
 extracted the 6.4.1 package to C:\tsm_images (again, a different
 installer: 7z. Why?!?)
 I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It 
 installed the framework, the server had to be rebooted and the FCM 
 installation continued afterwards.
 You stated that I had to copy the license file to c:\Program 
 Files\TSM\TDPsql afterwards, but that directory does not exist yet!
 I then installed the TDP client manually from 
 C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running 
 the setup.exe. The directory to c:\Program Files\TSM\TDPsql then was 
 created and I could copy the license file to it.
 After clicking the TDP for SQL link the setup wizard started and we 
 could successfully configure the TDP client. Now it works.

 So, the SetupFCM does not start the TDPsql installation afterwards 
 which seems to be a bug to me since the manual does not specify that 
 you have to do this manually afterwards.
 Thanks for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: vrijdag 1 november 2013 11:46
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 This may have been an issue with the 6.3.1 version.
 Did you get the latest 6.4.1 package?
http://www-01.ibm.com/support/docview.wss?uid=swg24035560
 After installing it, make sure the sqlclient.lic is in the 
 C:\Program Files\Tivoli\TSM\TDPSql directory.
 (or wherever you installed DP for SQL.)

 After doing so, start the MMC GUI.
 On the left hand side of the MMC GUI you should see a treeview that 
 looks something like this:


 IBM Tivoli Data Protection
   - IBM Tivoli Storage Manager
  - Dashboard - SERVER1
 - Manage
+ Configuration
+ Diagnostics
+ Learning

 If you are not seeing this, open a PMR, maybe something else is wrong 
 with the configuration seeing the license file.

 Thanks,

 Del

 


 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
 06:09:01 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 11/01/2013 06:09 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  According to the manual I have to run setupfcm.exe. This indeed 
  installs a link in the start menu to the TDP for SQL client. As soon

  as I click it, it start the console with IBM Tivoli Data Protection 
  listed, with IBM Tivoli FlashCopy Manager underneath, along with the

  license file not found error.
  The manual than states that the TSM configuration wizard should
start.
  It does

Re: TDP for SQL Server

[Loon, EJ van - SPLXM]

Hi Del!
According to the manual I have to run setupfcm.exe. This indeed installs
a link in the start menu to the TDP for SQL client. As soon as I click
it, it start the console with IBM Tivoli Data Protection listed, with
IBM Tivoli FlashCopy Manager underneath, along with the license file not
found error.
The manual than states that the TSM configuration wizard should start.
It does not. The manual states that you can start the wizard manually by
clicking Manage  Configuration  Wizard, but there is no Manage option
to click!
Thanks again for your help.
Kind regards,
Eric van Loon
AF/KLM Storage Engineering


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Del Hoobler
Sent: maandag 28 oktober 2013 14:20
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server

Hi Eric,

You might want to get the latest version, 6.4.1.

   http://www-01.ibm.com/support/docview.wss?uid=swg24035560

This has the latest support and fixes.

As Wanda stated, after you install, you need to run the setup wizard.
Here is a pointer to some installation/configuration steps:


http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql
.doc/t_dpsql_quick_inst_cfg.html


If you are still having issues, please call support.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
09:10:41 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 10/28/2013 09:12 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 We have installed the 6.3.1.0 client and copied the license file from 
 the 6.3.0.0 distribution (from Passport Advantage) into this 
 directory, but as soon as the DP for SQL Manager Console icon is 
 clicked, the console comes up with only the Flashcopy Manager
listed...
 Thanks for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: maandag 28 oktober 2013 12:05
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 This is expected. FlashCopy Manager, Data Protection for SQL, and Data

 Protection for Exchange now share the same MMC GUI interface.

 To make sure you have the correct product installed, look for a file 
 called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql 
 directory.


 Thanks,

 Del

 

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
 05:45:50 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 10/28/2013 05:47 AM
  Subject: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi guys!
 
  We are trying to install the TDP for SQL Server 6.3.1.0 client on 
  one of our SQL server, but instead of installing the TDP client it 
  installs the FlashCopy Manager client. The console does not list the

  TDP for SQL client after installation...
 
  Thank you very much for any help.
 
  Kind regards,
 
  Eric van Loon
 
  AF/KLM Storage Engineering
 
  
  For information, services and offers, please visit our web site:
  http://www.klm.com. This e-mail and any attachment may contain 
  confidential and privileged material intended for the addressee
only.
  If you are not the addressee, you are notified that no part of the 
  e-mail or any attachment may be disclosed, copied or distributed, 
  and that any other action related to this e-mail or attachment is 
  strictly

  prohibited, and may be unlawful. If you have received this e-mail by

  error, please notify the sender immediately by return e-mail, and 
  delete this message.
 
  Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ 
  or

  its employees shall not be liable for the incorrect or incomplete 
  transmission of this e-mail or any attachments, nor responsible for 
  any delay in receipt.
  Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
  Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
  registered number 33014286
  
 
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain 
 confidential and privileged material intended for the addressee only. 
 If you are not the addressee, you are notified that no part of the 
 e-mail or any attachment may be disclosed, copied or distributed, and 
 that any other action related to this e-mail or attachment is strictly

 prohibited, and may be unlawful. If you have received this e-mail by 
 error, please notify the sender immediately by return e-mail, and 
 delete this message.

 Koninklijke Luchtvaart

Re: TDP for SQL Server

[Del Hoobler]

Hi Eric,

This may have been an issue with the 6.3.1 version.
Did you get the latest 6.4.1 package?
   http://www-01.ibm.com/support/docview.wss?uid=swg24035560
After installing it, make sure the sqlclient.lic is
in the C:\Program Files\Tivoli\TSM\TDPSql directory.
(or wherever you installed DP for SQL.)

After doing so, start the MMC GUI.
On the left hand side of the MMC GUI you should see
a treeview that looks something like this:


IBM Tivoli Data Protection
  - IBM Tivoli Storage Manager
 - Dashboard - SERVER1
- Manage
   + Configuration
   + Diagnostics
   + Learning

If you are not seeing this, open a PMR, maybe something else
is wrong with the configuration seeing the license file.

Thanks,

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
06:09:01 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 11/01/2013 06:09 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 According to the manual I have to run setupfcm.exe. This indeed installs
 a link in the start menu to the TDP for SQL client. As soon as I click
 it, it start the console with IBM Tivoli Data Protection listed, with
 IBM Tivoli FlashCopy Manager underneath, along with the license file not
 found error.
 The manual than states that the TSM configuration wizard should start.
 It does not. The manual states that you can start the wizard manually by
 clicking Manage  Configuration  Wizard, but there is no Manage option
 to click!
 Thanks again for your help.
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
 Del Hoobler
 Sent: maandag 28 oktober 2013 14:20
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 You might want to get the latest version, 6.4.1.

http://www-01.ibm.com/support/docview.wss?uid=swg24035560

 This has the latest support and fixes.

 As Wanda stated, after you install, you need to run the setup wizard.
 Here is a pointer to some installation/configuration steps:


 http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql
 .doc/t_dpsql_quick_inst_cfg.html


 If you are still having issues, please call support.

 Thanks,

 Del

 

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
 09:10:41 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 10/28/2013 09:12 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  We have installed the 6.3.1.0 client and copied the license file from
  the 6.3.0.0 distribution (from Passport Advantage) into this
  directory, but as soon as the DP for SQL Manager Console icon is
  clicked, the console comes up with only the Flashcopy Manager
 listed...
  Thanks for your help!
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
  Of Del Hoobler
  Sent: maandag 28 oktober 2013 12:05
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL Server
 
  Hi Eric,
 
  This is expected. FlashCopy Manager, Data Protection for SQL, and Data

  Protection for Exchange now share the same MMC GUI interface.
 
  To make sure you have the correct product installed, look for a file
  called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql
  directory.
 
 
  Thanks,
 
  Del
 
  
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
  05:45:50 AM:
 
   From: Loon, EJ van - SPLXM eric-van.l...@klm.com
   To: ADSM-L@vm.marist.edu,
   Date: 10/28/2013 05:47 AM
   Subject: TDP for SQL Server
   Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
  
   Hi guys!
  
   We are trying to install the TDP for SQL Server 6.3.1.0 client on
   one of our SQL server, but instead of installing the TDP client it
   installs the FlashCopy Manager client. The console does not list the

   TDP for SQL client after installation...
  
   Thank you very much for any help.
  
   Kind regards,
  
   Eric van Loon
  
   AF/KLM Storage Engineering

Re: TDP for SQL Server

[Loon, EJ van - SPLXM]

Hi Del!
I removed the 6.3 client and installed 6.4.1. This installer is also not
working according to the manual. Here's what I did:

I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport
Advantage
I extracted the sqlclient.lic from the 6.4.0 package
I extracted the 6.4.1 package to C:\tsm_images (again, a different
installer: 7z. Why?!?)
I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It
installed the framework, the server had to be rebooted and the FCM
installation continued afterwards.
You stated that I had to copy the license file to c:\Program
Files\TSM\TDPsql afterwards, but that directory does not exist yet!
I then installed the TDP client manually from
C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running the
setup.exe. The directory to c:\Program Files\TSM\TDPsql then was created
and I could copy the license file to it.
After clicking the TDP for SQL link the setup wizard started and we
could successfully configure the TDP client. Now it works.

So, the SetupFCM does not start the TDPsql installation afterwards which
seems to be a bug to me since the manual does not specify that you have
to do this manually afterwards.
Thanks for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Del Hoobler
Sent: vrijdag 1 november 2013 11:46
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server

Hi Eric,

This may have been an issue with the 6.3.1 version.
Did you get the latest 6.4.1 package?
   http://www-01.ibm.com/support/docview.wss?uid=swg24035560
After installing it, make sure the sqlclient.lic is in the C:\Program
Files\Tivoli\TSM\TDPSql directory.
(or wherever you installed DP for SQL.)

After doing so, start the MMC GUI.
On the left hand side of the MMC GUI you should see a treeview that
looks something like this:


IBM Tivoli Data Protection
  - IBM Tivoli Storage Manager
 - Dashboard - SERVER1
- Manage
   + Configuration
   + Diagnostics
   + Learning

If you are not seeing this, open a PMR, maybe something else is wrong
with the configuration seeing the license file.

Thanks,

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
06:09:01 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 11/01/2013 06:09 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 According to the manual I have to run setupfcm.exe. This indeed 
 installs a link in the start menu to the TDP for SQL client. As soon 
 as I click it, it start the console with IBM Tivoli Data Protection 
 listed, with IBM Tivoli FlashCopy Manager underneath, along with the 
 license file not found error.
 The manual than states that the TSM configuration wizard should start.
 It does not. The manual states that you can start the wizard manually 
 by clicking Manage  Configuration  Wizard, but there is no Manage 
 option to click!
 Thanks again for your help.
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: maandag 28 oktober 2013 14:20
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 You might want to get the latest version, 6.4.1.

http://www-01.ibm.com/support/docview.wss?uid=swg24035560

 This has the latest support and fixes.

 As Wanda stated, after you install, you need to run the setup wizard.
 Here is a pointer to some installation/configuration steps:


 http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.s
 ql
 .doc/t_dpsql_quick_inst_cfg.html


 If you are still having issues, please call support.

 Thanks,

 Del

 

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
 09:10:41 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 10/28/2013 09:12 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  We have installed the 6.3.1.0 client and copied the license file 
  from the 6.3.0.0 distribution (from Passport Advantage) into this 
  directory, but as soon as the DP for SQL Manager Console icon is 
  clicked, the console comes up with only the Flashcopy Manager
 listed...
  Thanks for your help!
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
  Behalf Of Del Hoobler
  Sent: maandag 28 oktober 2013 12:05
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL Server
 
  Hi Eric,
 
  This is expected. FlashCopy Manager, Data Protection for SQL, and 
  Data

  Protection for Exchange now share the same MMC GUI interface.
 
  To make sure you

Re: TDP for SQL Server

[Del Hoobler]

Hi Eric,

What happens if you install 6.4.0 first,
then follow it with an upgrade to 6.4.1?

The book is written to follow that method since it is the best practice
method to get the paid (base) license installed first, then
follow it with the PTF (fix) package.

This is slightly different than the BA client, since the
BA client does not have the requirement of the license file.


Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Software Group - Cloud  Smarter Infrastructure
IBM Corporation



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
09:01:24 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 11/01/2013 09:03 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 I removed the 6.3 client and installed 6.4.1. This installer is also not
 working according to the manual. Here's what I did:

 I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport
 Advantage
 I extracted the sqlclient.lic from the 6.4.0 package
 I extracted the 6.4.1 package to C:\tsm_images (again, a different
 installer: 7z. Why?!?)
 I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It
 installed the framework, the server had to be rebooted and the FCM
 installation continued afterwards.
 You stated that I had to copy the license file to c:\Program
 Files\TSM\TDPsql afterwards, but that directory does not exist yet!
 I then installed the TDP client manually from
 C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running the
 setup.exe. The directory to c:\Program Files\TSM\TDPsql then was created
 and I could copy the license file to it.
 After clicking the TDP for SQL link the setup wizard started and we
 could successfully configure the TDP client. Now it works.

 So, the SetupFCM does not start the TDPsql installation afterwards which
 seems to be a bug to me since the manual does not specify that you have
 to do this manually afterwards.
 Thanks for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
 Del Hoobler
 Sent: vrijdag 1 november 2013 11:46
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 This may have been an issue with the 6.3.1 version.
 Did you get the latest 6.4.1 package?
http://www-01.ibm.com/support/docview.wss?uid=swg24035560
 After installing it, make sure the sqlclient.lic is in the C:\Program
 Files\Tivoli\TSM\TDPSql directory.
 (or wherever you installed DP for SQL.)

 After doing so, start the MMC GUI.
 On the left hand side of the MMC GUI you should see a treeview that
 looks something like this:


 IBM Tivoli Data Protection
   - IBM Tivoli Storage Manager
  - Dashboard - SERVER1
 - Manage
+ Configuration
+ Diagnostics
+ Learning

 If you are not seeing this, open a PMR, maybe something else is wrong
 with the configuration seeing the license file.

 Thanks,

 Del

 


 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
 06:09:01 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 11/01/2013 06:09 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  According to the manual I have to run setupfcm.exe. This indeed
  installs a link in the start menu to the TDP for SQL client. As soon
  as I click it, it start the console with IBM Tivoli Data Protection
  listed, with IBM Tivoli FlashCopy Manager underneath, along with the
  license file not found error.
  The manual than states that the TSM configuration wizard should start.
  It does not. The manual states that you can start the wizard manually
  by clicking Manage  Configuration  Wizard, but there is no Manage
  option to click!
  Thanks again for your help.
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
  Of Del Hoobler
  Sent: maandag 28 oktober 2013 14:20
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL Server
 
  Hi Eric,
 
  You might want to get the latest version, 6.4.1.
 
 http://www-01.ibm.com/support/docview.wss?uid=swg24035560
 
  This has the latest support and fixes.
 
  As Wanda stated, after you install, you need to run the setup wizard.
  Here is a pointer to some installation/configuration steps:
 
 
  http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.s
  ql
  .doc/t_dpsql_quick_inst_cfg.html
 
 
  If you are still having issues, please call support.
 
  Thanks,
 
  Del
 
  
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
  09:10:41 AM:
 
   From: Loon, EJ van

Re: TDP for SQL Server

[Loon, EJ van - SPLXM]

Hi Del!
I will have to try this on a different machine. I will let you know next
week.
If that's the new way to install the client, I think it has not improved
compared to the old way. We always installed the most recent patch level
and added the license file afterwards. It's much easier and faster,
don't you agree?
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Del Hoobler
Sent: vrijdag 1 november 2013 15:58
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server

Hi Eric,

What happens if you install 6.4.0 first, then follow it with an upgrade
to 6.4.1?

The book is written to follow that method since it is the best practice
method to get the paid (base) license installed first, then follow it
with the PTF (fix) package.

This is slightly different than the BA client, since the BA client does
not have the requirement of the license file.


Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Software Group - Cloud  Smarter Infrastructure IBM Corporation



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
09:01:24 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 11/01/2013 09:03 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 I removed the 6.3 client and installed 6.4.1. This installer is also 
 not working according to the manual. Here's what I did:

 I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport 
 Advantage I extracted the sqlclient.lic from the 6.4.0 package I 
 extracted the 6.4.1 package to C:\tsm_images (again, a different
 installer: 7z. Why?!?)
 I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It 
 installed the framework, the server had to be rebooted and the FCM 
 installation continued afterwards.
 You stated that I had to copy the license file to c:\Program 
 Files\TSM\TDPsql afterwards, but that directory does not exist yet!
 I then installed the TDP client manually from 
 C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running 
 the setup.exe. The directory to c:\Program Files\TSM\TDPsql then was 
 created and I could copy the license file to it.
 After clicking the TDP for SQL link the setup wizard started and we 
 could successfully configure the TDP client. Now it works.

 So, the SetupFCM does not start the TDPsql installation afterwards 
 which seems to be a bug to me since the manual does not specify that 
 you have to do this manually afterwards.
 Thanks for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Del Hoobler
 Sent: vrijdag 1 november 2013 11:46
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 This may have been an issue with the 6.3.1 version.
 Did you get the latest 6.4.1 package?
http://www-01.ibm.com/support/docview.wss?uid=swg24035560
 After installing it, make sure the sqlclient.lic is in the 
 C:\Program Files\Tivoli\TSM\TDPSql directory.
 (or wherever you installed DP for SQL.)

 After doing so, start the MMC GUI.
 On the left hand side of the MMC GUI you should see a treeview that 
 looks something like this:


 IBM Tivoli Data Protection
   - IBM Tivoli Storage Manager
  - Dashboard - SERVER1
 - Manage
+ Configuration
+ Diagnostics
+ Learning

 If you are not seeing this, open a PMR, maybe something else is wrong 
 with the configuration seeing the license file.

 Thanks,

 Del

 


 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
 06:09:01 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 11/01/2013 06:09 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  According to the manual I have to run setupfcm.exe. This indeed 
  installs a link in the start menu to the TDP for SQL client. As soon

  as I click it, it start the console with IBM Tivoli Data Protection 
  listed, with IBM Tivoli FlashCopy Manager underneath, along with the

  license file not found error.
  The manual than states that the TSM configuration wizard should
start.
  It does not. The manual states that you can start the wizard 
  manually by clicking Manage  Configuration  Wizard, but there is 
  no Manage option to click!
  Thanks again for your help.
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
  Behalf Of Del Hoobler
  Sent: maandag 28 oktober 2013 14:20
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL Server
 
  Hi Eric,
 
  You might want to get the latest version, 6.4.1

Re: TDP for SQL Server

[Del Hoobler]

Hi Eric,

I understand the point. I will pass the comment on the team.


Thanks,

Del


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
11:28:05 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 11/01/2013 11:29 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 I will have to try this on a different machine. I will let you know next
 week.
 If that's the new way to install the client, I think it has not improved
 compared to the old way. We always installed the most recent patch level
 and added the license file afterwards. It's much easier and faster,
 don't you agree?
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
 Del Hoobler
 Sent: vrijdag 1 november 2013 15:58
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 What happens if you install 6.4.0 first, then follow it with an upgrade
 to 6.4.1?

 The book is written to follow that method since it is the best practice
 method to get the paid (base) license installed first, then follow it
 with the PTF (fix) package.

 This is slightly different than the BA client, since the BA client does
 not have the requirement of the license file.


 Thanks,

 Del

 

 Del Hoobler
 Tivoli Storage Manager Development
 IBM Software Group - Cloud  Smarter Infrastructure IBM Corporation



 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
 09:01:24 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 11/01/2013 09:03 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  I removed the 6.3 client and installed 6.4.1. This installer is also
  not working according to the manual. Here's what I did:
 
  I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport
  Advantage I extracted the sqlclient.lic from the 6.4.0 package I
  extracted the 6.4.1 package to C:\tsm_images (again, a different
  installer: 7z. Why?!?)
  I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It
  installed the framework, the server had to be rebooted and the FCM
  installation continued afterwards.
  You stated that I had to copy the license file to c:\Program
  Files\TSM\TDPsql afterwards, but that directory does not exist yet!
  I then installed the TDP client manually from
  C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running
  the setup.exe. The directory to c:\Program Files\TSM\TDPsql then was
  created and I could copy the license file to it.
  After clicking the TDP for SQL link the setup wizard started and we
  could successfully configure the TDP client. Now it works.
 
  So, the SetupFCM does not start the TDPsql installation afterwards
  which seems to be a bug to me since the manual does not specify that
  you have to do this manually afterwards.
  Thanks for your help!
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
  Of Del Hoobler
  Sent: vrijdag 1 november 2013 11:46
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL Server
 
  Hi Eric,
 
  This may have been an issue with the 6.3.1 version.
  Did you get the latest 6.4.1 package?
 http://www-01.ibm.com/support/docview.wss?uid=swg24035560
  After installing it, make sure the sqlclient.lic is in the
  C:\Program Files\Tivoli\TSM\TDPSql directory.
  (or wherever you installed DP for SQL.)
 
  After doing so, start the MMC GUI.
  On the left hand side of the MMC GUI you should see a treeview that
  looks something like this:
 
 
  IBM Tivoli Data Protection
- IBM Tivoli Storage Manager
   - Dashboard - SERVER1
  - Manage
 + Configuration
 + Diagnostics
 + Learning
 
  If you are not seeing this, open a PMR, maybe something else is wrong
  with the configuration seeing the license file.
 
  Thanks,
 
  Del
 
  
 
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013
  06:09:01 AM:
 
   From: Loon, EJ van - SPLXM eric-van.l...@klm.com
   To: ADSM-L@vm.marist.edu,
   Date: 11/01/2013 06:09 AM
   Subject: Re: TDP for SQL Server
   Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
  
   Hi Del!
   According to the manual I have to run setupfcm.exe. This indeed
   installs a link in the start menu to the TDP for SQL client. As soon

   as I click it, it start the console with IBM Tivoli Data Protection
   listed, with IBM Tivoli FlashCopy Manager underneath, along with the

   license file not found error.
   The manual than states that the TSM configuration wizard should
 start.
   It does not. The manual

Re: TDP for SQL Server

[Del Hoobler]

Hi Eric,

This is expected. FlashCopy Manager, Data Protection for SQL,
and Data Protection for Exchange now share the same
MMC GUI interface.

To make sure you have the correct product installed,
look for a file called sqlclient.lic in the
C:\Program Files\Tivoli\TSM\TDPSql directory.


Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
05:45:50 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 10/28/2013 05:47 AM
 Subject: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi guys!

 We are trying to install the TDP for SQL Server 6.3.1.0 client on one of
 our SQL server, but instead of installing the TDP client it installs the
 FlashCopy Manager client. The console does not list the TDP for SQL
 client after installation...

 Thank you very much for any help.

 Kind regards,

 Eric van Loon

 AF/KLM Storage Engineering

 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain
 confidential and privileged material intended for the addressee
 only. If you are not the addressee, you are notified that no part of
 the e-mail or any attachment may be disclosed, copied or
 distributed, and that any other action related to this e-mail or
 attachment is strictly prohibited, and may be unlawful. If you have
 received this e-mail by error, please notify the sender immediately
 by return e-mail, and delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/
 or its employees shall not be liable for the incorrect or incomplete
 transmission of this e-mail or any attachments, nor responsible for
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
 Dutch Airlines) is registered in Amstelveen, The Netherlands, with
 registered number 33014286
 

Re: TDP for SQL Server

[Prather, Wanda]

Eric,
It's a documentation issue.
They repackaged the SQL client inside the Flashcopy manager GUI, and the 
install package does you no favors; it's a 2-step install now.
After you run the setup.exe, all you have installed is the Flashcopy Manager 
shell, you don't even have a tdpsql directory
.
Look in the directory where the package expanded, and run setupfcm.
Then go through it's setup wizard.  That's when the tdpsql directory gets 
created.

Wanda


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, 
EJ van - SPLXM
Sent: Monday, October 28, 2013 5:46 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL Server

Hi guys!

We are trying to install the TDP for SQL Server 6.3.1.0 client on one of our 
SQL server, but instead of installing the TDP client it installs the FlashCopy 
Manager client. The console does not list the TDP for SQL client after 
installation...

Thank you very much for any help.

Kind regards,

Eric van Loon

AF/KLM Storage Engineering


For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL Server

[Loon, EJ van - SPLXM]

Hi Del!
We have installed the 6.3.1.0 client and copied the license file from
the 6.3.0.0 distribution (from Passport Advantage) into this directory,
but as soon as the DP for SQL Manager Console icon is clicked, the
console comes up with only the Flashcopy Manager listed... 
Thanks for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Del Hoobler
Sent: maandag 28 oktober 2013 12:05
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Server

Hi Eric,

This is expected. FlashCopy Manager, Data Protection for SQL, and Data
Protection for Exchange now share the same MMC GUI interface.

To make sure you have the correct product installed, look for a file
called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql
directory.


Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
05:45:50 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 10/28/2013 05:47 AM
 Subject: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi guys!

 We are trying to install the TDP for SQL Server 6.3.1.0 client on one 
 of our SQL server, but instead of installing the TDP client it 
 installs the FlashCopy Manager client. The console does not list the 
 TDP for SQL client after installation...

 Thank you very much for any help.

 Kind regards,

 Eric van Loon

 AF/KLM Storage Engineering

 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain 
 confidential and privileged material intended for the addressee only. 
 If you are not the addressee, you are notified that no part of the 
 e-mail or any attachment may be disclosed, copied or distributed, and 
 that any other action related to this e-mail or attachment is strictly

 prohibited, and may be unlawful. If you have received this e-mail by 
 error, please notify the sender immediately by return e-mail, and 
 delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or

 its employees shall not be liable for the incorrect or incomplete 
 transmission of this e-mail or any attachments, nor responsible for 
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
 Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
 registered number 33014286
 


For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286

Re: TDP for SQL Server

[Del Hoobler]

Hi Eric,

You might want to get the latest version, 6.4.1.

   http://www-01.ibm.com/support/docview.wss?uid=swg24035560

This has the latest support and fixes.

As Wanda stated, after you install, you need to run the setup wizard.
Here is a pointer to some installation/configuration steps:


http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql.doc/t_dpsql_quick_inst_cfg.html


If you are still having issues, please call support.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
09:10:41 AM:

 From: Loon, EJ van - SPLXM eric-van.l...@klm.com
 To: ADSM-L@vm.marist.edu,
 Date: 10/28/2013 09:12 AM
 Subject: Re: TDP for SQL Server
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hi Del!
 We have installed the 6.3.1.0 client and copied the license file from
 the 6.3.0.0 distribution (from Passport Advantage) into this directory,
 but as soon as the DP for SQL Manager Console icon is clicked, the
 console comes up with only the Flashcopy Manager listed...
 Thanks for your help!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
 Del Hoobler
 Sent: maandag 28 oktober 2013 12:05
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: TDP for SQL Server

 Hi Eric,

 This is expected. FlashCopy Manager, Data Protection for SQL, and Data
 Protection for Exchange now share the same MMC GUI interface.

 To make sure you have the correct product installed, look for a file
 called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql
 directory.


 Thanks,

 Del

 

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
 05:45:50 AM:

  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 10/28/2013 05:47 AM
  Subject: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi guys!
 
  We are trying to install the TDP for SQL Server 6.3.1.0 client on one
  of our SQL server, but instead of installing the TDP client it
  installs the FlashCopy Manager client. The console does not list the
  TDP for SQL client after installation...
 
  Thank you very much for any help.
 
  Kind regards,
 
  Eric van Loon
 
  AF/KLM Storage Engineering
 
  
  For information, services and offers, please visit our web site:
  http://www.klm.com. This e-mail and any attachment may contain
  confidential and privileged material intended for the addressee only.
  If you are not the addressee, you are notified that no part of the
  e-mail or any attachment may be disclosed, copied or distributed, and
  that any other action related to this e-mail or attachment is strictly

  prohibited, and may be unlawful. If you have received this e-mail by
  error, please notify the sender immediately by return e-mail, and
  delete this message.
 
  Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or

  its employees shall not be liable for the incorrect or incomplete
  transmission of this e-mail or any attachments, nor responsible for
  any delay in receipt.
  Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
  Dutch Airlines) is registered in Amstelveen, The Netherlands, with
  registered number 33014286
  
 
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain
 confidential and privileged material intended for the addressee
 only. If you are not the addressee, you are notified that no part of
 the e-mail or any attachment may be disclosed, copied or
 distributed, and that any other action related to this e-mail or
 attachment is strictly prohibited, and may be unlawful. If you have
 received this e-mail by error, please notify the sender immediately
 by return e-mail, and delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/
 or its employees shall not be liable for the incorrect or incomplete
 transmission of this e-mail or any attachments, nor responsible for
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
 Dutch Airlines) is registered in Amstelveen, The Netherlands, with
 registered number 33014286
 

Re: TDP for SQL Server

[Stackwick, Stephen]

After I upgrade I always forget to go back into FCM to update the configuration 
to pick up the upgrade.

STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | 
stephen.stackw...@icfi.com | icfi.com
ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 
410.539.1135 (o)

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
 Of Del Hoobler
 Sent: Monday, October 28, 2013 9:20 AM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] TDP for SQL Server
 
 Hi Eric,
 
 You might want to get the latest version, 6.4.1.
 
http://www-01.ibm.com/support/docview.wss?uid=swg24035560
 
 This has the latest support and fixes.
 
 As Wanda stated, after you install, you need to run the setup wizard.
 Here is a pointer to some installation/configuration steps:
 
 
 http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql.doc
 /t_dpsql_quick_inst_cfg.html
 
 
 If you are still having issues, please call support.
 
 Thanks,
 
 Del
 
 
 
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
 09:10:41 AM:
 
  From: Loon, EJ van - SPLXM eric-van.l...@klm.com
  To: ADSM-L@vm.marist.edu,
  Date: 10/28/2013 09:12 AM
  Subject: Re: TDP for SQL Server
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Hi Del!
  We have installed the 6.3.1.0 client and copied the license file from
  the 6.3.0.0 distribution (from Passport Advantage) into this
  directory, but as soon as the DP for SQL Manager Console icon is
  clicked, the console comes up with only the Flashcopy Manager listed...
  Thanks for your help!
  Kind regards,
  Eric van Loon
  AF/KLM Storage Engineering
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
  Of Del Hoobler
  Sent: maandag 28 oktober 2013 12:05
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: TDP for SQL Server
 
  Hi Eric,
 
  This is expected. FlashCopy Manager, Data Protection for SQL, and Data
  Protection for Exchange now share the same MMC GUI interface.
 
  To make sure you have the correct product installed, look for a file
  called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql
  directory.
 
 
  Thanks,
 
  Del
 
  
 
  ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013
  05:45:50 AM:
 
   From: Loon, EJ van - SPLXM eric-van.l...@klm.com
   To: ADSM-L@vm.marist.edu,
   Date: 10/28/2013 05:47 AM
   Subject: TDP for SQL Server
   Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
  
   Hi guys!
  
   We are trying to install the TDP for SQL Server 6.3.1.0 client on
   one of our SQL server, but instead of installing the TDP client it
   installs the FlashCopy Manager client. The console does not list the
   TDP for SQL client after installation...
  
   Thank you very much for any help.
  
   Kind regards,
  
   Eric van Loon
  
   AF/KLM Storage Engineering
  
   
   For information, services and offers, please visit our web site:
   http://www.klm.com. This e-mail and any attachment may contain
   confidential and privileged material intended for the addressee only.
   If you are not the addressee, you are notified that no part of the
   e-mail or any attachment may be disclosed, copied or distributed,
   and that any other action related to this e-mail or attachment is
   strictly
 
   prohibited, and may be unlawful. If you have received this e-mail by
   error, please notify the sender immediately by return e-mail, and
   delete this message.
  
   Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/
   or
 
   its employees shall not be liable for the incorrect or incomplete
   transmission of this e-mail or any attachments, nor responsible for
   any delay in receipt.
   Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
   Dutch Airlines) is registered in Amstelveen, The Netherlands, with
   registered number 33014286
   
  
  
  For information, services and offers, please visit our web site:
  http://www.klm.com. This e-mail and any attachment may contain
  confidential and privileged material intended for the addressee only.
  If you are not the addressee, you are notified that no part of the
  e-mail or any attachment may be disclosed, copied or distributed, and
  that any other action related to this e-mail or attachment is strictly
  prohibited, and may be unlawful. If you have received this e-mail by
  error, please notify the sender immediately by return e-mail, and
  delete this message.
 
  Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or
  its employees shall not be liable for the incorrect or incomplete
  transmission of this e-mail or any attachments, nor responsible for
  any delay

Re: TDP for SQL in a cluster and setting passwords...

[Gopikrishna Muppidi]

Hello

There 3 steps to reset the password of the cluster resource group

1)reset the client password on TSM server level with standard password.

2)then run the below cmd on tsm client level with respected optfile,It will
prompt for the userid and password

dsmc q sched -optfile=optionfile

3)then bring the resource group online.

4)restart the scheduler service.


On Mon, Sep 9, 2013 at 3:00 PM, Rick Adamson
rickadam...@biloholdings.comwrote:

 Accept-Language: en-US
 Content-Language: en-US
 X-MS-Has-Attach:
 X-MS-TNEF-Correlator:
 x-originating-ip: [208.62.154.89]
 x-forefront-prvs: 09645BAC66
 x-forefront-antispam-report:
 SFV:NSPM;SFS:(377454003)(189002)(199002)(129404003)(13464003)(77096001)(56816003)(69226001)(15974865002)(80022001)(66066001)(74316001)(74366001)(46102001)(551544002)(19580395003)(19580405001)(83322001)(31966008)(47446002)(51856001)(74662001)(74502001)(83072001)(49866001)(47736001)(50986001)(47976001)(74706001)(4396001)(81342001)(74876001)(81542001)(76482001)(33646001)(81686001)(80976001)(76576001)(76796001)(54316002)(63696002)(76786001)(77982001)(81816001)(59766001)(56776001)(79102001)(65816001)(54356001)(53806001)(24736002)(80792004);DIR:OUT;SFP:;SCL:1;SRVR:BY2PR05MB062;H:
 BY2PR05MB062.namprd05.prod.outlook.com;CLIP:208.62.154.89
 ;RD:InfoNoRecords;MX:1;A:1;LANG:en;
 Content-Type: text/plain; charset=us-ascii
 Content-Transfer-Encoding: quoted-printable
 MIME-Version: 1.0
 X-OriginatorOrg: biloholdings.com
 X-Barracuda-Connect: mail-bl2lp0205.outbound.protection.outlook.com
 [207.46.163.205]
 X-Barracuda-Start-Time: 1378731611
 X-Barracuda-Encrypted: AES128-SHA
 X-Barracuda-URL: http://148.100.49.27:8000/cgi-mod/mark.cgi
 X-Virus-Scanned: by bsmtpd at marist.edu
 X-Barracuda-BRTS-Status: 1
 X-Barracuda-Spam-Score: 0.00
 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of
 TAG_LEVEL=3.5 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.5 tests=
 X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.140474
 Rule breakdown below
  pts rule name  description
  --
 --

 Hi Wanda,
 When it comes to SQL on a Win2008 server, I use an account that has local
 a=
 dministrator and sysadmin access to SQL, then I disable the UAC for admins
 =
 (User Account Control: Run all administrators in Admin Approval Mode).
 With=
 out this policy change I could not get the services to operate correctly.

 Optional, remove logon rights from the account used to manage the service
 t=
 o minimize security risks.

 Also, it is my experience that many times it is not acceptable to the
 busin=
 ess to fail the active instance of the cluster over to the passive server
 t=
 o sync the scheduler password. I log into the active machine,
 install/updat=
 e the scheduler service, change the properties so it does not affect the
 gr=
 oup if it fails, then bring it online. If it works successfully I export
 th=
 e password key for the SQL client from the registry, log onto the passive
 n=
 ode, install the service (which will have errors), then import the
 registry=
  key.=20

 Hope this helps
 -Rick Adamson



 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
 Pr=
 ather, Wanda
 Sent: Sunday, September 08, 2013 11:59 PM
 To: ADSM-L@VM.MARIST.EDU
 Subject: [ADSM-L] TDP for SQL in a cluster and setting passwords...

 TDP for SQL 6.4, Win2K8, SQL in a 2-node active-passive cluster

 TSM scheduler was installed on both nodes of the cluster, made a cluster
 re=
 source, registry key set as per instructions in the TDP for SQL 6.4 user
 gu=
 ide.

 Then the nodes were de-registered from TSM.
 Now we have to put them back (long story, don't ask).
 Nobody knows what the TSM password was, of course.

 So I reset the password on the TSM server end.
 Now trying to reset it on the nodes, with no success.
 I tried using the client setup wizard to change the password on the client
 =
 end; I tried running dsmc sched on the client end and responding to the
 pro=
 mpt, from both the active and passive side.
 But the password doesn't get changed, and authentication with the server
 st=
 ill fails with scheduler needs to prompt for password when we bring the
 r=
 esource online in cluster manager.

 Not sure if I'm suffering from an authority issue, or a clustering issue.
 To reset the scheduler password, do I have to first make the scheduler
 serv=
 ice NOT a cluster resource again?

 Thanks for any insight...
 W

 Wanda Prather  |  Senior Technical Specialist  | wanda.prat...@icfi.com | =
  www.icfi.com ICF International  | 401 E. Pratt St, Suite 2214,
 Baltimore, =
 MD 21202 | 410.539.1135 (o)

Re: TDP for SQL in a cluster and setting passwords...

[Rick Adamson]

Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
x-originating-ip: [208.62.154.89]
x-forefront-prvs: 09645BAC66
x-forefront-antispam-report: 
SFV:NSPM;SFS:(377454003)(189002)(199002)(129404003)(13464003)(77096001)(56816003)(69226001)(15974865002)(80022001)(66066001)(74316001)(74366001)(46102001)(551544002)(19580395003)(19580405001)(83322001)(31966008)(47446002)(51856001)(74662001)(74502001)(83072001)(49866001)(47736001)(50986001)(47976001)(74706001)(4396001)(81342001)(74876001)(81542001)(76482001)(33646001)(81686001)(80976001)(76576001)(76796001)(54316002)(63696002)(76786001)(77982001)(81816001)(59766001)(56776001)(79102001)(65816001)(54356001)(53806001)(24736002)(80792004);DIR:OUT;SFP:;SCL:1;SRVR:BY2PR05MB062;H:BY2PR05MB062.namprd05.prod.outlook.com;CLIP:208.62.154.89;RD:InfoNoRecords;MX:1;A:1;LANG:en;
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: biloholdings.com
X-Barracuda-Connect: 
mail-bl2lp0205.outbound.protection.outlook.com[207.46.163.205]
X-Barracuda-Start-Time: 1378731611
X-Barracuda-Encrypted: AES128-SHA
X-Barracuda-URL: http://148.100.49.27:8000/cgi-mod/mark.cgi
X-Virus-Scanned: by bsmtpd at marist.edu
X-Barracuda-BRTS-Status: 1
X-Barracuda-Spam-Score: 0.00
X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=3.5 
QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.5 tests=
X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.140474
Rule breakdown below
 pts rule name  description
 -- 
--

Hi Wanda,
When it comes to SQL on a Win2008 server, I use an account that has local a=
dministrator and sysadmin access to SQL, then I disable the UAC for admins =
(User Account Control: Run all administrators in Admin Approval Mode). With=
out this policy change I could not get the services to operate correctly.

Optional, remove logon rights from the account used to manage the service t=
o minimize security risks.

Also, it is my experience that many times it is not acceptable to the busin=
ess to fail the active instance of the cluster over to the passive server t=
o sync the scheduler password. I log into the active machine, install/updat=
e the scheduler service, change the properties so it does not affect the gr=
oup if it fails, then bring it online. If it works successfully I export th=
e password key for the SQL client from the registry, log onto the passive n=
ode, install the service (which will have errors), then import the registry=
 key.=20

Hope this helps
-Rick Adamson



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Pr=
ather, Wanda
Sent: Sunday, September 08, 2013 11:59 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL in a cluster and setting passwords...

TDP for SQL 6.4, Win2K8, SQL in a 2-node active-passive cluster

TSM scheduler was installed on both nodes of the cluster, made a cluster re=
source, registry key set as per instructions in the TDP for SQL 6.4 user gu=
ide.

Then the nodes were de-registered from TSM.
Now we have to put them back (long story, don't ask).
Nobody knows what the TSM password was, of course.

So I reset the password on the TSM server end.
Now trying to reset it on the nodes, with no success.
I tried using the client setup wizard to change the password on the client =
end; I tried running dsmc sched on the client end and responding to the pro=
mpt, from both the active and passive side.
But the password doesn't get changed, and authentication with the server st=
ill fails with scheduler needs to prompt for password when we bring the r=
esource online in cluster manager.

Not sure if I'm suffering from an authority issue, or a clustering issue.
To reset the scheduler password, do I have to first make the scheduler serv=
ice NOT a cluster resource again?

Thanks for any insight...
W

Wanda Prather  |  Senior Technical Specialist  | wanda.prat...@icfi.com  | =
 www.icfi.com ICF International  | 401 E. Pratt St, Suite 2214, Baltimore, =
MD 21202 | 410.539.1135 (o)

Re: TDP for SQL in a cluster and setting passwords

[Markus Engelhard]

Hi Wanda,

not sure about the cluster stuff, but why not try dsmcutil to change the
stored password?

Regards,

Markus



--
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail oder von Teilen dieser Mail ist nicht gestattet.

Wir haben alle verkehrsüblichen Maßnahmen unternommen, um das Risiko der
Verbreitung virenbefallener Software oder E-Mails zu minimieren, dennoch
raten wir Ihnen, Ihre eigenen Virenkontrollen auf alle Anhänge an dieser
Nachricht durchzuführen. Wir schließen außer für den Fall von Vorsatz oder
grober Fahrlässigkeit die Haftung für jeglichen Verlust oder Schäden durch
virenbefallene Software oder E-Mails aus.

Jede von der Bank versendete E-Mail ist sorgfältig erstellt worden, dennoch
schließen wir die rechtliche Verbindlichkeit aus; sie kann nicht zu einer
irgendwie gearteten Verpflichtung zu Lasten der Bank ausgelegt werden.
__

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of  the material in this
e-mail or of parts hereof is strictly forbidden.

We have taken precautions to minimize the risk of transmitting software
viruses but nevertheless advise you to carry out your own virus checks on
any attachment of this message. We accept no liability for loss or damage
caused by software viruses except in case of gross negligence or willful
behaviour.

Any e-mail messages from the Bank are sent in good faith, but shall not be
binding or construed as constituting any kind of obligation on the part of
the Bank.

Re: TDP for SQL /excludedb parm

[Del Hoobler]

Hi Steve,

There are no current plans to extend that capability to TDPSQLC.
You could use PowerShell to script it if you need that added capability.

Thanks,

Del


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/19/2013
09:47:02 AM:

 From: Schaub, Steve steve_sch...@bcbst.com
 To: ADSM-L@vm.marist.edu,
 Date: 02/19/2013 09:49 AM
 Subject: TDP for SQL /excludedb parm
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Tivoli folks,

 Are there any plans to allow wildcarding in the /excludedb parameter
 in the TDP?

 Thanks,

 Steve Schaub
 Systems Engineer II, Windows Backup/Recovery
 BlueCross BlueShield of Tennessee

 -
 Please see the following link for the BlueCross BlueShield of
 Tennessee E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL gui takes 20 min to display inactive

[Alex Paschal]

Hi, Steve.  If restoring a file takes multiple small volumes in one
pool, but only one large volume in another pool, TSM will choose the
pool with the fewest volumes/mounts required, even if the smaller
volumes are significantly faster.  This causes some problems with
restores choosing real tape over small file or VTL volumes.  Well, I say
that as if it's fact, but while I haven't seen that documented anywhere,
that's what I've observed.  I've also received hearsay confirmation from
various IBM sources that it is this way.  YMMV :-)  I think this might
have been addressed with the libtype=vtl, and I'd like to see
confirmation on that, but that wouldn't help you much with file class
volumes.

I recommend you check your actlog for the sessions in question to see if
they've been getting tape mounts during restores.  If so, try setting
your copypool unavailable to see if that alleviates the problem.
   update stgpool copypool access=unavailable

The other question is, why would the copypool volumes still be
available?  Is this only happening in the window between backup
stgpool and move drmedia?

On 12/27/2012 5:36 AM, Schaub, Steve wrote:

Thanks, Steve.
I checked, and the node does have backdel=y.  it almost acts like it is going 
to the copypool rather than the diskpool for the meta data, but that makes no 
sense.
-steve s

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven 
Harris
Sent: Saturday, December 22, 2012 1:39 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL gui takes 20 min to display inactive

Hi Steve.

Check to make sure that the node has backdel=yes specified.  I had one SQL 
server that was on a legal hold for 4 years and the restore screen took that 
long to come up because of the large number of objects.  If backdel is set to 
no, the logs won't be getting deleted and that may account for the large number 
of objects you are seeing.

Regards

Steve

Steven Harris

TSM Admin
Canberra Australia.





On 22/12/2012 12:26 AM, Schaub, Steve wrote:

Tsm server 6.2.4.0
Tsm client 6.2.3.0
Tdp client 6.3.0.1
Windows 2003EE x64

Our DBA's are complaining that when they have to use the TDP gui to restore older 
databases by selecting active/inactive, it sometimes takes 20+ minutes for 
the list of databases to refresh.

My first suspicion was that the meta data had somehow gotten off to tape, but I 
have confirmed the primary data is all on disk (ST03_DISK_P04), only copypool 
(ST03_TAPE_C04) is on tape.

Any ideas what would cause this behavior?

tsm: TSMBCP01q occ archer_sql ARCHER\COMPOUND\meta*

Node Name  Type Filespace   FSID StorageNumber of  Physical   Logical
  Name Pool Name  Files Space Space
 Occupied  Occupied
 (MB)  (MB)
--  -- - -- - - -
ARCHER_SQL Bkup ARCHER\CO-12 ST03_DISK-   142,148555.27662.44
   MPOUND\m-_P04
   eta\
ARCHER_SQL Bkup ARCHER\CO-12 ST03_TAPE-   141,452374.17374.17
   MPOUND\m-_C04
   eta\


tsm: TSMBCP01q stg st03_disk_p04

Storage  Device   EstimatedPctPct  High  Low  Next Stora-
Pool NameClass NameCapacity   Util   Migr   Mig  Mig  ge Pool
  Pct  Pct
---  --  --  -  -    ---  ---
ST03_DISK_-  DISK 100 G2.52.570   50  ST03_TAPE_-
P04   P04


Steve Schaub
Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of
Tennessee
-
Please see the following link for the BlueCross BlueShield of
Tennessee E-mail disclaimer:
http://www.bcbst.com/email_disclaimer.shtm


-
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL gui takes 20 min to display inactive

[Schaub, Steve]

Thanks, Steve.
I checked, and the node does have backdel=y.  it almost acts like it is going 
to the copypool rather than the diskpool for the meta data, but that makes no 
sense.
-steve s

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven 
Harris
Sent: Saturday, December 22, 2012 1:39 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL gui takes 20 min to display inactive

Hi Steve.

Check to make sure that the node has backdel=yes specified.  I had one SQL 
server that was on a legal hold for 4 years and the restore screen took that 
long to come up because of the large number of objects.  If backdel is set to 
no, the logs won't be getting deleted and that may account for the large number 
of objects you are seeing.

Regards

Steve

Steven Harris

TSM Admin
Canberra Australia.





On 22/12/2012 12:26 AM, Schaub, Steve wrote:
 Tsm server 6.2.4.0
 Tsm client 6.2.3.0
 Tdp client 6.3.0.1
 Windows 2003EE x64

 Our DBA's are complaining that when they have to use the TDP gui to restore 
 older databases by selecting active/inactive, it sometimes takes 20+ 
 minutes for the list of databases to refresh.

 My first suspicion was that the meta data had somehow gotten off to tape, but 
 I have confirmed the primary data is all on disk (ST03_DISK_P04), only 
 copypool (ST03_TAPE_C04) is on tape.

 Any ideas what would cause this behavior?

 tsm: TSMBCP01q occ archer_sql ARCHER\COMPOUND\meta*

 Node Name  Type Filespace   FSID StorageNumber of  Physical   Logical
  Name Pool Name  Files Space Space
 Occupied  Occupied
 (MB)  (MB)
 --  -- - -- - - -
 ARCHER_SQL Bkup ARCHER\CO-12 ST03_DISK-   142,148555.27662.44
   MPOUND\m-_P04
   eta\
 ARCHER_SQL Bkup ARCHER\CO-12 ST03_TAPE-   141,452374.17374.17
   MPOUND\m-_C04
   eta\


 tsm: TSMBCP01q stg st03_disk_p04

 Storage  Device   EstimatedPctPct  High  Low  Next Stora-
 Pool NameClass NameCapacity   Util   Migr   Mig  Mig  ge Pool
  Pct  Pct
 ---  --  --  -  -    ---  ---
 ST03_DISK_-  DISK 100 G2.52.570   50  ST03_TAPE_-
 P04   P04


 Steve Schaub
 Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of 
 Tennessee
 -
 Please see the following link for the BlueCross BlueShield of 
 Tennessee E-mail disclaimer:  
 http://www.bcbst.com/email_disclaimer.shtm

-
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL gui takes 20 min to display inactive

[Steven Harris]

Hi Steve.

Check to make sure that the node has backdel=yes specified.  I had one
SQL server that was on a legal hold for 4 years and the restore screen
took that long to come up because of the large number of objects.  If
backdel is set to no, the logs won't be getting deleted and that may
account for the large number of objects you are seeing.

Regards

Steve

Steven Harris

TSM Admin
Canberra Australia.





On 22/12/2012 12:26 AM, Schaub, Steve wrote:

Tsm server 6.2.4.0
Tsm client 6.2.3.0
Tdp client 6.3.0.1
Windows 2003EE x64

Our DBA's are complaining that when they have to use the TDP gui to restore older 
databases by selecting active/inactive, it sometimes takes 20+ minutes for 
the list of databases to refresh.

My first suspicion was that the meta data had somehow gotten off to tape, but I 
have confirmed the primary data is all on disk (ST03_DISK_P04), only copypool 
(ST03_TAPE_C04) is on tape.

Any ideas what would cause this behavior?

tsm: TSMBCP01q occ archer_sql ARCHER\COMPOUND\meta*

Node Name  Type Filespace   FSID StorageNumber of  Physical   Logical
 Name Pool Name  Files Space Space
Occupied  Occupied
(MB)  (MB)
--  -- - -- - - -
ARCHER_SQL Bkup ARCHER\CO-12 ST03_DISK-   142,148555.27662.44
  MPOUND\m-_P04
  eta\
ARCHER_SQL Bkup ARCHER\CO-12 ST03_TAPE-   141,452374.17374.17
  MPOUND\m-_C04
  eta\


tsm: TSMBCP01q stg st03_disk_p04

Storage  Device   EstimatedPctPct  High  Low  Next Stora-
Pool NameClass NameCapacity   Util   Migr   Mig  Mig  ge Pool
 Pct  Pct
---  --  --  -  -    ---  ---
ST03_DISK_-  DISK 100 G2.52.570   50  ST03_TAPE_-
P04   P04


Steve Schaub
Systems Engineer II, Windows Backup/Recovery
BlueCross BlueShield of Tennessee
-
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL-MAIL with flash copy manager Schedules

[Del Hoobler]

Hi Murat,

You cannot set different policies for backups of the same object name
using the same NODENAME. That is a fundamental behavior of
backup objects in a TSM/FCM environment. There are ways to
to solve your requirement.

For SQL, if you want different policies for the same object name,
you will need to have different NODENAMEs. All backups under
different NODENAMEs will get managed separately.

The same is true for Exchange, except with Exchange, you have another 
possibility. You can create a COPY type backup and bind it to
another management class that has different policy settings.
In this case, you do not need a different NODENAME.
This will only give you two different policy possibilities.
In order to solve your daily, weekly, yearly requirement,
you will need to have a different NODENAME.

Please take a look at the User's Guides for Data Protection
for SQL and Exchange. Search for the word policy. 
If you are still not able to get this working, open a PMR 
with IBM support and they can assist you.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/17/2012 
01:35:06 AM:

 From: Murat ÖRDEKBAY murat.ordek...@compro.com.tr
 To: ADSM-L@vm.marist.edu
 Date: 05/17/2012 01:39 AM
 Subject: TDP for SQL-MAIL with flash copy manager Schedules
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
 Hi all,
 
 
 
 I installed both agent sql and exchange servers. I want to different
 schedules. Daily schedule (7 version), Weekly schedule(60 version), 
Yearly
 schedule(5 version). What can i do.
 
 
 
 
 
 Versions,
 
 
 
 TDP for SQL 6.3
 
 TDP for Exchange 6.3
 
 
 
 TSM 6.3
 
 Exchange server 2010
 
 SQL Server 2008
 
 
 
 Thank you
 
 
 
 
 
 Murat
 

Re: TDP for SQL 2008 Windows 2008 R2

[Del Hoobler]

There is no such thing as TDP for Ms SQL 2008...

However, the latest version of Data Protection for SQL,
Data Protection for SQL 5.5.5 does support legacy and VSS backups
for SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2.


Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/10/2011
12:36:23 PM:

 From: cc1702004 tsm-fo...@backupcentral.com
 To: ADSM-L@vm.marist.edu
 Date: 01/10/2011 12:37 PM
 Subject: TDP for SQL 2008 Windows 2008 R2
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Hello,

 May I know whether the TDP for Ms SQL 2008 still supports legacy
backup?

 Thanks

Re: TDP for SQL vs SQL dumps

[Tyree, David]

The DBAs claim they can configure the SQL boxes to send an email with
the success/failure of each db dump. 

As long as somebody actually monitors the emails..

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Prather, Wanda
Sent: Wednesday, June 09, 2010 4:49 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL vs SQL dumps

That works fine.
Upside:  No TDP for SQL license required
Downside:  
You (the TSM admin) get no notification if those dumps fail (or
accidentally get turned off). 

I went into a new TSM customer last year and we found 7 out of 12 SQL
servers that were supposedly backing up to disk had somehow gotten the
backups turned off...


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Tyree, David
Sent: Wednesday, June 09, 2010 3:05 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL vs SQL dumps


I was talking about backups with a couple of our DBAs
and they mentioned using SQL scripts on the server to export the
database and then use the regular TSM client to backup the exported file
instead of using the TDP. 

They suggested building a server with a bunch of shares,
one share for each of our SQL servers. Then go into each of the SQL
servers and set up a script that dumps the database to share that was
created for it. The dump location would have the regular TSM client
running to catch all the incoming SQL files. 

The DBAs did some db dumps and also some log dumps as
well and were able to restore them back into the server and they seemed
happy with the process. 

Is there anything I'm missing here? It seems like a
reasonable idea to me. 

 

David Tyree 
Interface Analyst 
South Georgia Medical Center 
229.333.1155 

Confidential Notice:  This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

Re: TDP for SQL vs SQL dumps

[Thorneycroft, Doug]

That's the way or DBA prefers it. He schedules the dumps with the
database tools,
and I just back up the dump files.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Tyree, David
Sent: Wednesday, June 09, 2010 12:05 PM
To: ADSM-L@VM.MARIST.EDU
Subject: TDP for SQL vs SQL dumps

I was talking about backups with a couple of our DBAs
and they mentioned using SQL scripts on the server to export the
database and then use the regular TSM client to backup the exported file
instead of using the TDP. 

They suggested building a server with a bunch of shares,
one share for each of our SQL servers. Then go into each of the SQL
servers and set up a script that dumps the database to share that was
created for it. The dump location would have the regular TSM client
running to catch all the incoming SQL files. 

The DBAs did some db dumps and also some log dumps as
well and were able to restore them back into the server and they seemed
happy with the process. 

Is there anything I'm missing here? It seems like a
reasonable idea to me. 

 

David Tyree 
Interface Analyst 
South Georgia Medical Center 
229.333.1155 

Confidential Notice:  This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

Re: TDP for SQL vs SQL dumps

[Prather, Wanda]

That works fine.
Upside:  No TDP for SQL license required
Downside:  
You (the TSM admin) get no notification if those dumps fail (or
accidentally get turned off). 

I went into a new TSM customer last year and we found 7 out of 12 SQL
servers that were supposedly backing up to disk had somehow gotten the
backups turned off...


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Tyree, David
Sent: Wednesday, June 09, 2010 3:05 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL vs SQL dumps


I was talking about backups with a couple of our DBAs
and they mentioned using SQL scripts on the server to export the
database and then use the regular TSM client to backup the exported file
instead of using the TDP. 

They suggested building a server with a bunch of shares,
one share for each of our SQL servers. Then go into each of the SQL
servers and set up a script that dumps the database to share that was
created for it. The dump location would have the regular TSM client
running to catch all the incoming SQL files. 

The DBAs did some db dumps and also some log dumps as
well and were able to restore them back into the server and they seemed
happy with the process. 

Is there anything I'm missing here? It seems like a
reasonable idea to me. 

 

David Tyree 
Interface Analyst 
South Georgia Medical Center 
229.333.1155 

Confidential Notice:  This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

Re: TDP for SQL vs SQL dumps

[Remco Post]

The TDP provides a few things:

- versioning
- easy restore
- shortest path between the live database and the final destination of the 
backup, thus the lowest number of things that can go wrong

Everybody always prefers to do things the way they've always been done. Nobody 
likes changes.

Dumping a db to disk, and then moving/copying that data to TSM means that you 
spend a bit of money on the diskspace that you need for the dumps. With big 
databases, that might be quite a bit of money. Also, because the dumps have to 
be complete before you can copy the data to TSM, there is an additional window 
for data-loss.

It makes no sense implementing a TDP for a single 2kb database, but neither 
does it to dedicate an additional few TB of disk to keep your dumps and then 
copy them to TSM. There is no single truth, it all depends. I like TDP, I like 
to have all backup related logging at the TSM server, even if the backups 
aren't scheduled by TSM. I like to be able to tell my customers 'if it's in 
TSM, it can be restored'. Now how do you guarantee the quality of a two-step 
process? What if the intermediate disk is full, or broken, or? Who will 
check the consistency of the dumps?

On 9 jun 2010, at 21:04, Tyree, David wrote:

   I was talking about backups with a couple of our DBAs
 and they mentioned using SQL scripts on the server to export the
 database and then use the regular TSM client to backup the exported file
 instead of using the TDP. 
 
   They suggested building a server with a bunch of shares,
 one share for each of our SQL servers. Then go into each of the SQL
 servers and set up a script that dumps the database to share that was
 created for it. The dump location would have the regular TSM client
 running to catch all the incoming SQL files. 
 
   The DBAs did some db dumps and also some log dumps as
 well and were able to restore them back into the server and they seemed
 happy with the process. 
 
   Is there anything I'm missing here? It seems like a
 reasonable idea to me. 
 
 
 
 David Tyree 
 Interface Analyst 
 South Georgia Medical Center 
 229.333.1155 
 
 Confidential Notice:  This e-mail message, including any attachments, is
 for the sole use of the intended recipient(s) and may contain
 confidential and privileged information.  Any unauthorized review, use,
 disclosure or distribution is prohibited.  If you are not the intended
 recipient, please contact the sender by reply e-mail and destroy all
 copies of the original message.

-- 
Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: TDP for SQL vs SQL dumps

[Huebner,Andy,FORT WORTH,IT]

We have done that in the past and it worked just fine.  We built the SQL Dump 
on our backup server (not TSM at the time) and that allowed the backup server 
to dump the data straight to tape.  We also had a batch process to move the 
files to the bit bucket after they got old.
The TDP is much simpler, but as long as the DBAs are happy and aware I am not 
worried.

Andy Huebner


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, 
David
Sent: Wednesday, June 09, 2010 2:05 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL vs SQL dumps

I was talking about backups with a couple of our DBAs
and they mentioned using SQL scripts on the server to export the
database and then use the regular TSM client to backup the exported file
instead of using the TDP.

They suggested building a server with a bunch of shares,
one share for each of our SQL servers. Then go into each of the SQL
servers and set up a script that dumps the database to share that was
created for it. The dump location would have the regular TSM client
running to catch all the incoming SQL files.

The DBAs did some db dumps and also some log dumps as
well and were able to restore them back into the server and they seemed
happy with the process.

Is there anything I'm missing here? It seems like a
reasonable idea to me.



David Tyree
Interface Analyst
South Georgia Medical Center
229.333.1155

Confidential Notice:  This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.

Thank you.

Re: TDP for SQL 5.5.4 ?

[BT İşletim ve Teknik Destek Bölümü]

Thanks a lot !

Regards,

Tuncel Mutlu

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Del 
Hoobler
Sent: Saturday, June 05, 2010 3:08 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL 5.5.4 ?

Tuncel,

Look here:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v554/

It should be there now.

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/04/2010
07:13:40 AM:

 [image removed]

 TDP for SQL 5.5.4 ?

 Tuncel Mutlu

 to:

 ADSM-L

 06/04/2010 07:14 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Please respond to ADSM: Dist Stor Manager

 I am trying to download the latest fixpack for TDP for SQL, but the
 given link to the ftp site doesn't exist.

 ftp://public.dhe.ibm.com/storage/tivoli-storage-management/
 maintenance/tivoli-data-protection/ntsql/v554

 The latest entry is v553.

 Is there any other place to download it ?







Bu e-posta ve muhtemel eklerinde verilen bilgiler kişiye özel ve gizli olup, 
yalnızca mesajda belirlenen alıcı ile ilgilidir.Size yanlışlıkla ulaşmışsa 
lütfen göndericiye bilgi veriniz, mesajı siliniz ve içeriğini başka bir kişiye 
açıklamayınız, herhangi bir ortama kopyalamayınız. Bu mesaj aksi sözleşme ile 
belirtilmedikçe herhangi bir finansal işlem teklifi, alımı, satımı veya 
herhangi bir havalenin teyidi gibi bankacılık işlemi yapılması amacını 
taşımamaktadır.Verilen tüm bilgilerin doğruluğu ve bütünlüğünün garantisi 
verilmemekte olup, önceden bildirilmeksizin değiştirilebilecektir.Bu mesajın 
içeriği Bankamızın resmi görüşlerini yansıtmayabileceğinden Akbank T.A.Ş. 
hiçbir hukuki sorumluluğu kabul etmez.

Re: TDP for SQL 5.5.4 ?

[Del Hoobler]

Tuncel,

Look here:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v554/

It should be there now.

Del




ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/04/2010
07:13:40 AM:

 [image removed]

 TDP for SQL 5.5.4 ?

 Tuncel Mutlu

 to:

 ADSM-L

 06/04/2010 07:14 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 Please respond to ADSM: Dist Stor Manager

 I am trying to download the latest fixpack for TDP for SQL, but the
 given link to the ftp site doesn't exist.

 ftp://public.dhe.ibm.com/storage/tivoli-storage-management/
 maintenance/tivoli-data-protection/ntsql/v554

 The latest entry is v553.

 Is there any other place to download it ?

Re: TDP for SQL 5.5.2.0 error

[Del Hoobler]

Hi Steve,

Try these technote articles to see if they help at all.

http://www-01.ibm.com/support/docview.wss?rs=667uid=swg21321372

http://www-01.ibm.com/support/docview.wss?rs=667uid=swg21321370

http://www-01.ibm.com/support/docview.wss?rs=666context=SSTFZRdc=DB560dc=DB520uid=swg21372932loc=en_UScs=UTF-8lang=enrss=ct666tivoli


The following prerequisites are also required and are installed
when you install DP for SQL 5.5.2 if not already present on your machine.
All of these prerequisites are downward compatible with
SQL Server 2005 and SQL Server 2000.

Microsoft .NET Framework version 2.0 (or later)
Microsoft Core XML Services (MSXML) 6.0 (or later)
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Management Objects
Microsoft SQL Server System CLR Types


Please make sure those were installed correctly.

If you are still having issues, please call IBM support and the
IBM service team can analyze more closely.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/29/2009
12:20:25 PM:

 [image removed]

 Re: TDP for SQL 5.5.2.0 error

 Schaub, Steve

 to:

 ADSM-L

 07/29/2009 12:22 PM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 Del,
 Since SQL2000 is not involved, and I'm not doing VSS backups, the
 only prereqs I saw were for SP2 on both the OS and SQL2005, which were
met.
 As a test, I dropped back to TDP 5.5.0.0 and it worked fine, but
 then it stopped working when I upgraded to 5.5.2.0.  I then dropped
 back to 5.5.0.0 and upgraded to 5.5.1.0 and it is still working.
 Apparently there is something in the TDP 5.5.2.0 that is more fussy?
 Thanks,
 -steve

Re: TDP for SQL 5.5.2.0 error

[Del Hoobler]

Steve,

Could not load file or assembly 'Microsoft.SqlServer.Smo,
Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

typically means you do not have one of the prereqs installed.
Please double-check them.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/29/2009
10:48:08 AM:

 [image removed]

 TDP for SQL 5.5.2.0 error

 Schaub, Steve

 to:

 ADSM-L

 07/29/2009 10:49 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 W2K3 R2 Enterprise x64
 Tsm client 5.5.1.0
 TDP 5.5.2.0

 When I try to drill down, I get this error.  The only hits I get
 from google are related to sql2000 or sql2008 installs, but this
 server only has sql2005 installed.  I verified that the prereqs are
 in place.  My sql guy is stumped as well.  Help!


 07/29/2009 10:20:36

=
 07/29/2009 10:20:36 Request   : QUERY SQL
 07/29/2009 10:20:36

-
 07/29/2009 10:20:36 ACO5422E Received the following from the MS SQL
server:
 07/29/2009 10:20:36 Could not load file or assembly
 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral,
 PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The
 system cannot find the file specified.

 Steve Schaub
 Systems Engineer, Windows
 BlueCross BlueShield of Tennessee


 -
 Please see the following link for the BlueCross BlueShield of
 Tennessee E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL 5.5.2.0 error

[Sanju Chacko]

Could you pls try removing the sql native client and installing it
again?
The error seems to be related to pre-reqs

Thanks,
Sanju


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Schaub, Steve
Sent: Wednesday, July 29, 2009 8:18 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP for SQL 5.5.2.0 error

W2K3 R2 Enterprise x64
Tsm client 5.5.1.0
TDP 5.5.2.0

When I try to drill down, I get this error.  The only hits I get from
google are related to sql2000 or sql2008 installs, but this server only
has sql2005 installed.  I verified that the prereqs are in place.  My
sql guy is stumped as well.  Help!


07/29/2009 10:20:36

=
07/29/2009 10:20:36 Request   : QUERY SQL
07/29/2009 10:20:36

-
07/29/2009 10:20:36 ACO5422E Received the following from the MS SQL
server:
07/29/2009 10:20:36 Could not load file or assembly
'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system
cannot find the file specified.

Steve Schaub
Systems Engineer, Windows
BlueCross BlueShield of Tennessee


-
Please see the following link for the BlueCross BlueShield of Tennessee
E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL 5.5.2.0 error

[Schaub, Steve]

Del,
Since SQL2000 is not involved, and I'm not doing VSS backups, the only prereqs 
I saw were for SP2 on both the OS and SQL2005, which were met.
As a test, I dropped back to TDP 5.5.0.0 and it worked fine, but then it 
stopped working when I upgraded to 5.5.2.0.  I then dropped back to 5.5.0.0 and 
upgraded to 5.5.1.0 and it is still working.
Apparently there is something in the TDP 5.5.2.0 that is more fussy?
Thanks,
-steve

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Del 
Hoobler
Sent: Wednesday, July 29, 2009 11:13 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL 5.5.2.0 error

Steve,

Could not load file or assembly 'Microsoft.SqlServer.Smo,
Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

typically means you do not have one of the prereqs installed.
Please double-check them.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/29/2009
10:48:08 AM:

 [image removed]

 TDP for SQL 5.5.2.0 error

 Schaub, Steve

 to:

 ADSM-L

 07/29/2009 10:49 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 W2K3 R2 Enterprise x64
 Tsm client 5.5.1.0
 TDP 5.5.2.0

 When I try to drill down, I get this error.  The only hits I get
 from google are related to sql2000 or sql2008 installs, but this
 server only has sql2005 installed.  I verified that the prereqs are
 in place.  My sql guy is stumped as well.  Help!


 07/29/2009 10:20:36

=
 07/29/2009 10:20:36 Request   : QUERY SQL
 07/29/2009 10:20:36

-
 07/29/2009 10:20:36 ACO5422E Received the following from the MS SQL
server:
 07/29/2009 10:20:36 Could not load file or assembly
 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral,
 PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The
 system cannot find the file specified.

 Steve Schaub
 Systems Engineer, Windows
 BlueCross BlueShield of Tennessee


 -
 Please see the following link for the BlueCross BlueShield of
 Tennessee E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

-
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL Database backups - Specify order

[Del Hoobler]

Michele,

If you truly want one of your databases to get backed up first,
I recommend that you change your backup script to have separate
invocations of the backups, with the second invocation skipping
the one you backed up in the first invocation...
...i.e. something like this:

 .
 tdpsqlc backup bigdb full
 tdpsqlc backup * full /excludedb=bigdb
 .


Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/27/2009
12:40:44 PM:

 [image removed]

 TDP for SQL Database backups - Specify order

 mricca

 to:

 ADSM-L

 05/27/2009 07:54 PM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM-L

 Can I specify what order I want my databases to backup in?  I have a
 very large database that the DBA's want to backup first.
 If so, is this done in the cmd file itself?

Re: TDP FOR SQL

[Lepre, James]

Hello Everyone,

 

  Does anyone know where I can get the trial license for the TDP for
SQL?

 

Thank you 

 

James 

 


  
  
---
Confidentiality Notice: The information in this e-mail and any attachments 
thereto is intended for the named recipient(s) only.  This e-mail, including 
any attachments, may contain information that is privileged and confidential  
and subject to legal restrictions and penalties regarding its unauthorized 
disclosure or other use.  If you are not the intended recipient, you are hereby 
notified that any disclosure, copying, distribution, or the taking of any 
action or inaction in reliance on the contents of this e-mail and any of its 
attachments is STRICTLY PROHIBITED.  If you have received this e-mail in error, 
please immediately notify the sender via return e-mail; delete this e-mail and 
all attachments from your e-mail  system and your computer system and network; 
and destroy any paper copies you may have in your possession. Thank you for 
your cooperation.

Re: TDP FOR SQL

[Hart, Charles A]

Your IBM rep?   

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lepre, 
James
Sent: Wednesday, May 20, 2009 1:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP FOR SQL

Hello Everyone,

 

  Does anyone know where I can get the trial license for the TDP for SQL?

 

Thank you 

 

James 

 


  
  
---
Confidentiality Notice: The information in this e-mail and any attachments 
thereto is intended for the named recipient(s) only.  This e-mail, including 
any attachments, may contain information that is privileged and confidential  
and subject to legal restrictions and penalties regarding its unauthorized 
disclosure or other use.  If you are not the intended recipient, you are hereby 
notified that any disclosure, copying, distribution, or the taking of any 
action or inaction in reliance on the contents of this e-mail and any of its 
attachments is STRICTLY PROHIBITED.  If you have received this e-mail in error, 
please immediately notify the sender via return e-mail; delete this e-mail and 
all attachments from your e-mail  system and your computer system and network; 
and destroy any paper copies you may have in your possession. Thank you for 
your cooperation.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

Re: TDP for SQL don't truncate the logs

[Del Hoobler]

Christian,

This is normal and correct behavior.

In the SQL Server Full Recovery model, in order to truncate log,
you must run a log backup.

You will see that in the Microsoft docs and the DP/SQL User's Guide.
Here is an excerpt from the Microsoft documentation:

---
 Transaction Log Truncation

  If log records were never deleted from the transaction log, it
would
  eventually fill all the disk space that is available to the
physical
  log files. Log truncation automatically frees disk space
  for reuse by the transaction log.

 Except when delayed for some reason, log truncation occurs
automatically
 as follows:

 * Under the simple recovery model, after a checkpoint.
 * Under the full recovery model or bulk-logged recovery model,
   after a log backup, if a checkpoint has occurred since the
   previous backup.
---

Thanks,

Del


ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/19/2009
08:15:36 AM:

 [image removed]

 TDP for SQL don't truncate the logs

 Christian Svensson

 to:

 ADSM-L

 02/19/2009 08:16 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 Hi *SMers,
 I had a lot of fun with you all at Pulse09 in Vegas. I hope I will
 see you all again at Pulse 2010 in Vegas the 24th of Feb. :)

 Anyway, I have a fun problem with a SQL 2005 Server on Windows
 2003 running with TDP 5.5.1 x86 and TSM Server 5.4 on AIX version x.x
 But since a wild back the FULL backup that we do on SQL will not
 truncate the logs anymore, but if we do a LOG backup then will it
 truncate the logs without any issue.
 What I do see in the GUI is that the Truncate Checkbox i gray out in
 the GUI and when we choose LOG backup it is visible again but we can
 not backup all LOGs of some reason and TDP tell us that does logs
 are truncated by SQL it self's.

 The backups works fine and we can do restore of the databases but
 not truncate the logs without running a LOG backup after the full.

 I just wonder if anyone have any idea why this is happening and if
 the customer I working with has enable anything in SQL that don't
 let TSM to truncate the logs as normal?

 Del, do you have any idea? You are IBM's SQL/Exchange expert.

Re: TDP MS SQL X32 / X64

[Remco Post]

Del already mentioned this, basically, you can't backup 32 bit sql  
running on win 64 bit. You'll have to upgrade your sql server to 64  
bit, or downgrade your windows to 32 bit.


On 11 sep 2008, at 00:37, Patel, Ankur wrote:


Boris,

I have recently setup TDP Backups for SQL 64 bit.
Not sure about SQL x32 on windows x64.

My setup:
TSM B/A Client x64 v5.5.1.0
TSM TDP x64 v5.5.0.0
SQL Server 2005 x64
windows Server 2003 R2 Enterprise x64 Edition SP2
Backup Method: Legacy






Regards,


Ankur Patel

TSM Administrator
Sydney.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On  
Behalf Of

Herrmann, Boris
Sent: Wednesday, 10 September 2008 12:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP MS SQL X32 / X64

Hello all,

we've got a Windows 2003 64 Bit System with a MS SQL Database (32  
Bit).

We've installed TSM BA Client 5.5.1 (64 Bit).

But which version of TDP must we use (32 Bit or 64 Bit?)

With kind regards,
Boris

DISCLAIMER

Confidential Communication: This email and any attachments are  
intended for the addressee(s)
only and are confidential. They may contain legally privileged or  
copyright material. If you
are not the intended recipient, please contact the sender  
immediately by reply email and
delete this email and any attachments. You must not read, copy, use,  
distribute or disclose
the contents of this email without consent and Harvey Norman  
Holdings Limited ACN 003 237 545
(and its related subsidiaries) (“Harvey Norman”) does not accept  
responsibility for any

unauthorised use or reliance on the contents of this email.

Harvey Norman does not represent or warrant that the integrity of  
this email has been maintained
or that it is free from errors, viruses, interceptions or  
interference. Any views expressed by

the sender do not necessarily represent the views of Harvey Norman.

This notice should not be removed from this email.



--

Remco Post
[EMAIL PROTECTED]
+31 6 24821 622

Re: TDP MS SQL X32 / X64

[Del Hoobler]

Boris,

Officially, Data Protection for SQL only supports
the x64 version while running on an x64 operating system and
the x32 version while running on an x64 operating system.

I am still trying to understand why you would want to
run SQL Server 32-bit on a 64-bit OS.

Thanks,

Del




 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 Hello all,

 we've got a Windows 2003 64 Bit System with a MS SQL Database (32 Bit).
 We've installed TSM BA Client 5.5.1 (64 Bit).

 But which version of TDP must we use (32 Bit or 64 Bit?)

 With kind regards,
 Boris

Re: TDP MS SQL X32 / X64

[Patel, Ankur]

Boris,

I have recently setup TDP Backups for SQL 64 bit.
Not sure about SQL x32 on windows x64.

My setup:
TSM B/A Client x64 v5.5.1.0
TSM TDP x64 v5.5.0.0
SQL Server 2005 x64
windows Server 2003 R2 Enterprise x64 Edition SP2
Backup Method: Legacy

 


 

Regards,


Ankur Patel

TSM Administrator
Sydney.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Herrmann, Boris
Sent: Wednesday, 10 September 2008 12:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP MS SQL X32 / X64

Hello all,
 
we've got a Windows 2003 64 Bit System with a MS SQL Database (32 Bit).
We've installed TSM BA Client 5.5.1 (64 Bit).
 
But which version of TDP must we use (32 Bit or 64 Bit?)
 
With kind regards,
Boris

DISCLAIMER

Confidential Communication: This email and any attachments are intended for the 
addressee(s)
only and are confidential. They may contain legally privileged or copyright 
material. If you
are not the intended recipient, please contact the sender immediately by reply 
email and 
delete this email and any attachments. You must not read, copy, use, distribute 
or disclose 
the contents of this email without consent and Harvey Norman Holdings Limited 
ACN 003 237 545
(and its related subsidiaries) (“Harvey Norman”) does not accept responsibility 
for any
unauthorised use or reliance on the contents of this email.

Harvey Norman does not represent or warrant that the integrity of this email 
has been maintained
or that it is free from errors, viruses, interceptions or interference. Any 
views expressed by
the sender do not necessarily represent the views of Harvey Norman.

This notice should not be removed from this email.

Re: TDP for SQL 5.5 error ACO5422E

[Del Hoobler]

Hi Steve,

In the Data Protection for SQL User's Guide, we mention this...

Starting with Data Protection for SQL 5.5.0,
if you are still running with SQL Server 2000,
there are additional requirements:

SQL Server 2000 must be at Service Pack 4 (or later).
In addition, the following software is also required when
using SQL Server 2000 with Data Protection for SQL 5.5.0:
*  Microsoft .NET Framework version 2.0 (or later)
*  Microsoft Core XML Services (MSXML) 6.0 (or later)
*  Microsoft SQL Server Native Client
*  Microsoft SQL Server 2005 Management Objects Collection

Here are the links to obtain them:

* Microsoft .NET Framework Version 2.0 from:
http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5displaylang=en

* Microsoft Core XML Services (MSXML) 6.0 (or later),
  Microsoft SQL Server Native Client,
  Microsoft SQL Server 2005 Management Objects Collection
  SQL Server 2000 customers will need to install the Feature Pack
  for Microsoft SQL Server 2005 that can be downloaded from:
http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDCdisplaylang=en

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 06/19/2008
09:26:03 AM:

 [image removed]

 TDP for SQL 5.5 error ACO5422E

 Schaub, Steve

 to:

 ADSM-L

 06/19/2008 09:26 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 Tsm server 5.4.3.2

 Tsm client 5.5.0.0

 Tdp for sql server 5.5.0.0

 Win2k3 sp2

 Sql2000



 Getting the following error trying to backup or restore to a sql2000
 instance that I just installed the tdp on.  Cant seem to find any
 relevant hits on Microsoft or ibm.  Any else seen this?  It almost looks
 like the tdp is looking for sql2005, which of course is not there.





 Could not load file or assembly 'Microsoft.SqlServer.Smo,
 Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or
 one of its dependencies. The system cannot find the file specified.



 Thanks,



 Steve Schaub

 Systems Engineer, Windows

 Blue Cross Blue Shield of Tennessee

 423-535-6574 (desk)

 423-785-7347 (mobile)



 Please see the following link for the BlueCross BlueShield of
 Tennessee E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL 5.5 error ACO5422E

[Schaub, Steve]

Thanks, Del.  I looked through the guide, but must have overlooked this
section.
-steve

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Del Hoobler
Sent: Thursday, June 19, 2008 9:42 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP for SQL 5.5 error ACO5422E

Hi Steve,

In the Data Protection for SQL User's Guide, we mention this...

Starting with Data Protection for SQL 5.5.0,
if you are still running with SQL Server 2000,
there are additional requirements:

SQL Server 2000 must be at Service Pack 4 (or later).
In addition, the following software is also required when
using SQL Server 2000 with Data Protection for SQL 5.5.0:
*  Microsoft .NET Framework version 2.0 (or later)
*  Microsoft Core XML Services (MSXML) 6.0 (or later)
*  Microsoft SQL Server Native Client
*  Microsoft SQL Server 2005 Management Objects Collection

Here are the links to obtain them:

* Microsoft .NET Framework Version 2.0 from:
http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4
B0D-8EDD-AAB15C5E04F5displaylang=en

* Microsoft Core XML Services (MSXML) 6.0 (or later),
  Microsoft SQL Server Native Client,
  Microsoft SQL Server 2005 Management Objects Collection
  SQL Server 2000 customers will need to install the Feature Pack
  for Microsoft SQL Server 2005 that can be downloaded from:
http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4
479-9B91-9E8B9D835CDCdisplaylang=en

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 06/19/2008
09:26:03 AM:

 [image removed]

 TDP for SQL 5.5 error ACO5422E

 Schaub, Steve

 to:

 ADSM-L

 06/19/2008 09:26 AM

 Sent by:

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Please respond to ADSM: Dist Stor Manager

 Tsm server 5.4.3.2

 Tsm client 5.5.0.0

 Tdp for sql server 5.5.0.0

 Win2k3 sp2

 Sql2000



 Getting the following error trying to backup or restore to a sql2000
 instance that I just installed the tdp on.  Cant seem to find any
 relevant hits on Microsoft or ibm.  Any else seen this?  It almost
looks
 like the tdp is looking for sql2005, which of course is not there.





 Could not load file or assembly 'Microsoft.SqlServer.Smo,
 Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
or
 one of its dependencies. The system cannot find the file specified.



 Thanks,



 Steve Schaub

 Systems Engineer, Windows

 Blue Cross Blue Shield of Tennessee

 423-535-6574 (desk)

 423-785-7347 (mobile)



 Please see the following link for the BlueCross BlueShield of
 Tennessee E-mail disclaimer:
http://www.bcbst.com/email_disclaimer.shtm
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

Re: TDP for SQL Excludes?

[Del Hoobler]

You need to place them directly in the DSM.OPT file for
Data Protection for SQL.

Try this:

   EXCLUDE CO-AFSFRAUD1\...\nobackup*\...\*

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/01/2008
08:51:12 AM:

 Hi Everyone,

 I'm trying to come up with an TDP for SQL exclude for any database
 name beginning with nobackup on sever CO-AFSFRAUD1. I'm putting
 the excludes in the client options tlogs on the TSM server and
 they're the first to be evaluated. Here's what I've tried so far:

 q clopt tlogs

 ...
 INCLEXCL 100,090 No exclude CO-AFSFRAUD1\...\nobackup*\...\*
 INCLEXCL 100,095 No exclude CO-AFSFRAUD1\...\meta\...\nobackup*\...\*
 INCLEXCL 100,096 No exclude CO-AFSFRAUD1\meta\...\nobackup*\...\*

 None of these appear to be working. i was wondering if any of you
 might give me some guidance on this.

 Many Thanks,

 john

 i'ii


 -
 NOTICE: This communication is intended only for the person or
 entity to whom it is addressed and may contain confidential,
 proprietary, and/or privileged material. Unless you are the
 intended addressee, any review, reliance, dissemination,
 distribution, copying or use whatsoever of this communication is
 strictly prohibited. If you received this in error, please reply
 immediately and delete the material from all computers. Email sent
 through the Internet is not secure. Do not use email to send us
 confidential information such as credit card numbers, PIN numbers,
 passwords, Social Security Numbers, Account numbers, or other
 important and confidential information.

Re: TDP for SQL question

[Del Hoobler]

Paul,

If you need to restore from the new node name, you would launch
the CLI or GUI specifying the alternate options file name.
For example, in the example below:

GUI:   TDPSQL /TSMOPTFILE=DSMARCH.OPT
CLI:   TDPSQLC RESTORE dbname full /TSMOPTFILE=DSMARCH.OPT

This will tell Data Protection for SQL to connect
to the TSM Server using the alternate options file,
thus the alternate NODENAME.

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/22/2008
11:54:12 PM:

 OK - I have done this and it is working as far as backing up the SQL
 database goes.

 Now what do I do if I need to restore from this new node name back onto
 the client?

 Do I need to do anything with the dsm.opt and dsmarch.opt files before
 starting the restore?


  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
  Behalf Of Del Hoobler
  Sent: Saturday, 4 August 2007 2:37 AM
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: [ADSM-L] TDP for SQL question
 
  Paul,
 
  Typically...  I see that people will name their node
  the same as their primary SQL node with an extension.
  Something like:
  Primary:   SQLSRV23_SQL
  Archive:   SQLSRV23_SQL_ARCH
 
  And they will have a separate DSM.OPT file, something like
  DSMARCH.OPT that has the archive nodename.
 
  Thanks,
 
  Del

Re: TDP for SQL question

[Paul Dudley]

OK - I have done this and it is working as far as backing up the SQL
database goes.

Now what do I do if I need to restore from this new node name back onto
the client?

Do I need to do anything with the dsm.opt and dsmarch.opt files before
starting the restore?

Regards
Paul Dudley

Senior IT Systems Administrator
ANL IT Operations Dept.
ANL Container Line
[EMAIL PROTECTED]
03-9257-0603
http://www.anl.com.au



 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
 Behalf Of Del Hoobler
 Sent: Saturday, 4 August 2007 2:37 AM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] TDP for SQL question

 Paul,

 Typically...  I see that people will name their node
 the same as their primary SQL node with an extension.
 Something like:
 Primary:   SQLSRV23_SQL
 Archive:   SQLSRV23_SQL_ARCH

 And they will have a separate DSM.OPT file, something like
 DSMARCH.OPT that has the archive nodename.

 Thanks,

 Del

 

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on
 08/03/2007
 12:53:23 AM:

  I have been told that if I want to create an archive backup of an
SQL
  database via TDP for SQL, then I should create a separate node name
in
  TSM (such as SQL_Archive) and then backup using that node name
once
 a
  month (for example) and make sure to bind those backups to a
management
  class that has the long term settings that meet our requirements.
 
  What else is involved in setting this up? On the client do I have to
  create another dsm.opt file with the new node name to match what I
set
  up on the TSM server?
 
  Regards
  Paul Dudley





ANL DISCLAIMER
This e-mail and any file attached is confidential, and intended solely to the 
named addressees. Any unauthorised dissemination or use is strictly prohibited. 
If you received this e-mail in error, please immediately notify the sender by 
return e-mail from your system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: TDP For SQL Error ACO5402E

[Del Hoobler]

Bob,

Sometimes this occurs when you are running SQL Server Express
or a previous SQL Server installation did not completely
install and/or uninstall correctly.

What version of SQL Server are you running?
Run these commands and paste the results:

osql -E -S server-name -q SELECT @@VERSION
osql -E -S server-name -q SELECT @@SERVERNAME

Replace server-name with your SQL Server instance name.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/02/2007
03:53:01 PM:

 I have gone so far as to create a new account with all the correct
 permissions but am still receiving the same errors.  Thanks for the
 info - I had already read most of the posts here that returned this
 specific error.

Re: TDP For SQL Error ACO5402E

[Del Hoobler]

1. Are you able to perform a backup using the the internal backup
   tool within the SQL Server Management Studio?

2. Do you have other SQL Servers in your environment?
   Are they having the same problem?

3. Are you running in a cluster? If so, are you specifying the
   /SQLSERVER=srv-name parameter when you launch the GUI
   or the CLI command?

4. Does the SQL Server log give any information on the problem?


If you cannot get this working, please open a PMR with IBM
so IBM support can gather a trace to get some diagnostics data
to help troubleshoot this problem.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/03/2007
02:02:33 PM:

 Here are the results of the querys.  Everything looks okay to me.
 Any other suggestions?

 C:\Documents and Settings\Administrator.FTNETosql -E -S ftdb1 -q
 SELECT @@VERSION

  Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
 Feb 13 2007 23:02:48
 Copyright (c) 1988-2005 Microsoft Corporation
 Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack
2)

 (1 row affected)


 C:\Documents and Settings\Administrator.FTNETosql -E -S ftdb1 -q
 SELECT @@SERVERNAME

  FTDB1

 (1 row affected)

Re: TDP For SQL Error ACO5402E

[Larry Clark]

From another post with the same problem:

was related to service account for SQL missing from registry. Reset account
and all is fine...
- Original Message -
From: bobrains [EMAIL PROTECTED]
To: ADSM-L@VM.MARIST.EDU
Sent: Tuesday, October 02, 2007 10:42 AM
Subject: [ADSM-L] TDP For SQL Error ACO5402E



I have installed TDP for SQL onto an existing system and am receiving error
ACO5402E.  I am also receiving the following error in the Windows
Application event log.

SQLVDI: Loc=IdentitySQLServer. Desc=MSSQL$FTDB1. ErrorCode=(1060) The
specified service does not exist as an installed service. Process=5284
Thread=5332 Client Instance=FTDB1. VD=.

I have researched the TSM error on IBM's web site and none of the items
listed there as a possible cause are present.  Obviously from the Windows
event log it appears that some part of the SQL install is missing, corrupt
or otherwise unavailable.

Any ideas would be appreciated greatly.

Thanks,
Bob

+--
|This was sent by [EMAIL PROTECTED] via Backup Central.
|Forward SPAM to [EMAIL PROTECTED]
+--

Re: TDP for SQL advice

[Del Hoobler]

Hi Paul,

Data Protection for SQL can certainly run LOG backups.

You could modify your automated scheduled batch file
to call the a SQL Server job to shrink the files.
For example, something like this:

   tdpsqlc backup * full
   tdpsqlc backup * log
   osql -E -i shinkjob.sql

where shinkjob.sql is a TSQL command file to
shrink the log for you.

Thanks,

Del




ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/02/2007
11:56:00 PM:

 We currently perform MS SQL database backups using TDP (using the
 tdpsqlc backup * full command)

 We then use Enterprise Manager to run a log backup (using the BACKUP LOG
 command) followed by a log shrink job (using the DBCC SHRINKFILE
 command)

 Is there a way to do all of these within TDP for SQL?

 Regards
 Paul

Re: TDP for SQL question

[Del Hoobler]

Paul,

Typically...  I see that people will name their node
the same as their primary SQL node with an extension.
Something like:
Primary:   SQLSRV23_SQL
Archive:   SQLSRV23_SQL_ARCH

And they will have a separate DSM.OPT file, something like
DSMARCH.OPT that has the archive nodename.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/03/2007
12:53:23 AM:

 I have been told that if I want to create an archive backup of an SQL
 database via TDP for SQL, then I should create a separate node name in
 TSM (such as SQL_Archive) and then backup using that node name once a
 month (for example) and make sure to bind those backups to a management
 class that has the long term settings that meet our requirements.

 What else is involved in setting this up? On the client do I have to
 create another dsm.opt file with the new node name to match what I set
 up on the TSM server?

 Regards
 Paul Dudley

Re: TDP for SQL question

[Stuart Lamble]

On 03/08/2007, at 2:53 PM, Paul Dudley wrote:


I have been told that if I want to create an archive backup of an
SQL
database via TDP for SQL, then I should create a separate node name in
TSM (such as SQL_Archive) and then backup using that node name
once a
month (for example) and make sure to bind those backups to a
management
class that has the long term settings that meet our requirements.

What else is involved in setting this up? On the client do I have to
create another dsm.opt file with the new node name to match what I set
up on the TSM server?


In the context of the BA client, you can create multiple server
stanzas in dsm.sys to point at different TSM instances and/or node
names - eg, we do this with one particular system so that we can hold
an image backup for ten days normally, but once a week, put one aside
for eight weeks. The dsm.sys for this node looks like:

servername (instance)_8WR
   commmethod tcpip
   tcpport(port)
   tcpserveraddress   (server)
   passwordaccess generate
[...]
   nodename (client)_8wr

servername (instance)
   commmethod tcpip
   tcpport(port)
   tcpserveraddress   (server)
   passwordaccess generate
[...]
   nodename  (client)

All that is in dsm.opt is a line servername (instance), so that
backups by default go to the client's standard node; for the 8 week
retention, we add a -se=(instance)_8WR, and TSM does the right
thing. (The '[...]' signals where I've cut out a number of TCP/IP
options, along with other client-side options.)

How to do this for a TDP client is left as an exercise for the
reader. :-) Hopefully, it should give you some ideas. Good luck.

Re: TDP for SQL advice

[Wanda Prather]

I think so (not being an SQL guru I'm now sure what shrink means exactly.)

Look at the TDP for SQL book, there are some parms you can add after the
backup * full that determines whether the log is reset or not.


 We currently perform SQL database backups using TDP (using the tdpsqlc
 backup * full command)



 We then use Enterprise Manager to run a log backup (using the BACKUP LOG
 command) followed by a log shrink job (using the DBCC SHRINKFILE
 command)



 Is there a way to do all of these within TDP for SQL?



 Regards

 Paul





 Paul Dudley

 ANL IT Operations Dept.

 ANL Container Line

 [EMAIL PROTECTED]

 03-9257-0603

 http://www.anl.com.au











 ANL - CELEBRATING 50 YEARS

 ANL DISCLAIMER
 This e-mail and any file attached is confidential, and intended solely to
 the named addressees. Any unauthorised dissemination or use is strictly
 prohibited. If you received this e-mail in error, please immediately
 notify the sender by return e-mail from your system. Please do not copy,
 use or make reference to it for any purpose, or disclose its contents to
 any person.

Re: TDP for SQL restore question

[Paul Dudley]

Thanks for that clear and concise explanation. It appears that is
exactly what is happening. After 40 - 45 minutes the actual restore part
of it started and it has now restored 3 Gb of the database.


Paul Dudley
ANL IT Operations Dept.



 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
 Behalf Of David Longo
 Sent: Thursday, 28 June 2007 11:49 AM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] TDP for SQL restore question

 Maybe DB was smaller when you restored to D drive, or D is faster disk
than E.

 For this size you need bigger timeout, I have COMMTIMEOUT on
 TSM server set to 15,000 seconds (250 minutes)

 What is happening is that SQL (not TSM) is building the DB
 for the data to be restored to.  If it was only say 5GB, you would
barely notice.
 When DB is built, then the restore starts flying!

 David Longo

  Paul Dudley [EMAIL PROTECTED] 6/27/2007 9:41 PM 
 I am currently trying to restore a database from our production server
 onto the E drive of a test server.

 I have previously been able to restore a database from our production
 server onto the D drive of the test server.

 The database is 40 Gb in size.

 When I have tried this previously the session has timed out after 5
 minutes. I have increased the idle time out to 120 minutes.

 It is currently trying to restore and the output from the q sess
 command shows that 3.2 Mb of bytes have been sent. This amount of
bytes
 was sent in the first minute of the restore session after the tape was
 mounted. Since then it has stayed at 3.2 Mb for the past 35 minutes.
The
 session state according to q sess is SendW.

 The load on the client server is quite low - between 1% and 5%. There
is
 more than enough disk space to restore the database. I have checked
 Enterprise Manager and there is not much activity on the server.

 There are no other processes running on the TSM server.

 If this session times out and the restore fails after 120 minutes how
 can I work out why this has happened? Is there anything I can do to
make
 it work? As stated above I have been able to restore the same sized
 database onto the D drive of the same client server.

 Thanks
 Paul



 Paul Dudley
 ANL IT Operations Dept.
 ANL Container Line
 [EMAIL PROTECTED]





 ANL - CELEBRATING 50 YEARS

 ANL DISCLAIMER
 This e-mail and any file attached is confidential, and intended solely
to the
 named addressees. Any unauthorised dissemination or use is strictly
 prohibited. If you received this e-mail in error, please immediately
notify the
 sender by return e-mail from your system. Please do not copy, use or
make
 reference to it for any purpose, or disclose its contents to any
person.




ANL - CELEBRATING 50 YEARS

ANL DISCLAIMER
This e-mail and any file attached is confidential, and intended solely to the 
named addressees. Any unauthorised dissemination or use is strictly prohibited. 
If you received this e-mail in error, please immediately notify the sender by 
return e-mail from your system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: TDP for SQL - archive normal backup?

[Del Hoobler]

Paul,

No. If you want to create backups that are kept for longer term
than your normal Data Protection for SQL backups, you could
create a separate nodename, for example, SQLSRV10_ARCH,
and back up using that node once a week or once a month,
(or whatever your needs are) and make sure to bind those
backups to a management class that has the long term
settings that meet your requirements.

Thanks,

Del




ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/26/2006
09:28:37 PM:

 If I have run a normal TDP for SQL database backup onto my TSM tape
 library, is there any way to grab that backup and archive it?



 Regards

 Paul

Re: TDP for SQL - archive normal backup?

[Mark Stapleton]

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Paul Dudley
If I have run a normal TDP for SQL database backup onto my TSM tape
library, is there any way to grab that backup and archive it?

Nope. The TDP agents do not (at this time) support archives. Nor can you
put it on a backupset tape, since backupsets do not support API-centric
data, which is what TDP agents produce.

Your only chance to is to run an export, and you will have to export at
least the entire filespace the backed-up file belongs to.

--
Mark Stapleton ([EMAIL PROTECTED])
Senior TSM consultant

Re: TDP for SQL - space in database name

[Del Hoobler]

Dan,

Yes, it can have a space. Use quotes around the database name when
specifying Data Protection for SQL commands. For example:



C:\Program Files\Tivoli\TSM\TDPSqltdpsqlc backup Name with a space full

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 2, Level 1.06
(C) Copyright IBM Corporation 1997, 2006. All rights reserved.


Starting SQL database backup...


Beginning full backup for database Name with a space, 1 of 1.
Full: 0   Read: 2182896  Written: 2182896  Rate: 1,403.38 Kb/Sec
Backup of Name with a space completed successfully.


Total SQL backups selected:   1
Total SQL backups attempted:  1
Total SQL backups completed:  1
Total SQL backups excluded:   0
Total SQL backups inactivated:0

Throughput rate:  1,402.46 Kb/Sec
Total bytes transferred:  2,182,896
Elapsed processing time:  1.52 Secs

=

Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Corporation



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/27/2006
12:19:50 PM:

 I have a very simple question, when adding the name for a SQL database
 in the TDP for SQL's cmd file can the database have a space in the name.
 If not can you add quotes or any other sort of marker to allow it.



 Thank you



 Dan Cyr

Re: TDP for SQL Management Classes

[Adrian Compton]

Hi Leigh,

Thank you so much for your help. I will test tonight and see if my problem
is resolved.

Kind Regards
Adrian Compton





 Leigh Reed
 [EMAIL PROTECTED]
   To
 Sent by: ADSM:   ADSM-L@vm.marist.edu
 Dist Stor  cc
 Manager
 [EMAIL PROTECTED] Subject
 .edu [ADSM-L] TDP for SQL Management
   Classes

 03/10/06 12:44


 Please respond to
 ADSM: Dist Stor
 Manager
 [EMAIL PROTECTED]
   .edu






Adrian

You don't mention whether you are using the same nodename or different.
I see that you mention 3 opt files.

I think that the key to this is that you must use 3 different nodenames;

sql_daily, sql_monthly, sql_yearly.

The reason is that if you use the same nodename, the TDP rebinds all
previous backups to the MC you specify with the current full. Therefore
you won't achieve what you are looking for.

Also with the separate nodename approach, I find it easier to manage the
schedules, the occupancy and the tapes.

If you are looking to see if the backups are in the correct management
classes,

select * from backups where node_name='sqlservername' and
class_name='monthly'

If you want to get detail on specific dbs, you can use the hl_name

select * from backups where node_name='sqlservername' and
class_name='monthly' and hl_name='\master\'

Leigh




-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Adrian Compton
Sent: 03 October 2006 09:09
To: ADSM-L@VM.MARIST.EDU
Subject: [SPAM: 4.000] [ADSM-L] TDP for SQL Management Classes

Hi,

I am having problems trying to setup the following and wonder if anyone
can
shed some light on this or have done so themselves.

I am backing up a number of SQL Databases. I am not worried about the
sizes, or whuich databases, but only require to do a full backup
including
any logs.
I have a daily schedule running and keep the versions for a week.

I want to also have a full backup/archive at month end (keep for 1 year)
and also a yearly(keep for 7 years) backups

I have setup 3 different sql.cmd files i.e Daily, monthly and yearly,
and
at the end of each of the include statement in the 3 opt files(also
daily,
monthly and yearly), put the relevant management classes.

Will this provide me with what I am looking to achieve. I am trying to
find
out where to look to see that the backups have gone to the correct
management classes.

Any assistance would be most appreciated.

Kind regards

Adrian Compton

Re: TDP for SQL Large DB Restoration

[Del Hoobler]

Pranav,

The SQL Server is performing the preformat of your SQL database files.
The amount of time it will take depends on the types of disks, speed of
disks, and database file layout.
Data Protection for SQL is blocked until the SQL Server finishes
the database preformat. I would boost COMMTIMEOUT to a very high number
to find out what you will need to set the value at.
For example, start with:

 SETOPT COMMTIMEOUT 9

and then examine the operations to find out how long it actually takes.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/04/2006
12:00:10 AM:

 Hi,

 We are facing peculiar problem and request help to resolve it on
war-foot
 basis.


 We had a SQL DB running as a back-end to SAP in Win2k cluster. We are
able
 to successfully backup of our on-line SQL DB of 180GB approx. using TDP
 For SQL 5.3 on the autoloader connected to TSM server on LAN everyday.
 However, restoring same  fails with an error:

 ANR0481W Session 609 for node DBGRP (TDP MSSQL) terminated - client did
 not respond within 800 seconds.

 Restore process continue to format db for a long hours and then restore
 ends prematurely dismount the volume mounted in the drive.  We have
 already increased committimeout option from various values to as large
as
 28800. Even at such high value, restore operation ends after 6 to 8 hrs
of
 long wait.

 We are not sure what value we should use as a committimeout to restore
 approx. 180GB DB.

 Any help will be highly appreciated.

 Regards
 Pranav

Re: TDP for SQL Large DB Restoration

[Weeks, Debbie]

We are also experiencing this same issue with the TDP SQL client.  We
just restored a 41 GB database in about an hour and a half.  We
previously had cancelled the restore several times because the session
was in a SendW, and we thought it was hung.  Then it failed because it
timed out after an hour.  I finally tried maxing out the commtimeout,
and we just let it go.  The session remained in a SendW the entire time.
Yet when it completed, all of the data had been transferred.  Is it
normal for the session to remain in a SendW even while data is being
transferred? 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Del Hoobler
Sent: Wednesday, October 04, 2006 10:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Large DB Restoration

Pranav,

The SQL Server is performing the preformat of your SQL database files.
The amount of time it will take depends on the types of disks, speed of
disks, and database file layout.
Data Protection for SQL is blocked until the SQL Server finishes the
database preformat. I would boost COMMTIMEOUT to a very high number to
find out what you will need to set the value at.
For example, start with:

 SETOPT COMMTIMEOUT 9

and then examine the operations to find out how long it actually takes.

Thanks,

Del



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/04/2006
12:00:10 AM:

 Hi,

 We are facing peculiar problem and request help to resolve it on
war-foot
 basis.


 We had a SQL DB running as a back-end to SAP in Win2k cluster. We are
able
 to successfully backup of our on-line SQL DB of 180GB approx. using 
 TDP For SQL 5.3 on the autoloader connected to TSM server on LAN
everyday.
 However, restoring same  fails with an error:

 ANR0481W Session 609 for node DBGRP (TDP MSSQL) terminated - client 
 did not respond within 800 seconds.

 Restore process continue to format db for a long hours and then 
 restore ends prematurely dismount the volume mounted in the drive.  We

 have already increased committimeout option from various values to as 
 large
as
 28800. Even at such high value, restore operation ends after 6 to 8 
 hrs
of
 long wait.

 We are not sure what value we should use as a committimeout to restore

 approx. 180GB DB.

 Any help will be highly appreciated.

 Regards
 Pranav

Re: TDP for SQL Large DB Restoration

[Del Hoobler]

This is expected behavior. This is documented in the DP/SQL User's Guide:

   Note: When restoring large SQL databases, specifying a value of
 at least 1 in the commtimeout option will help prevent
 a restore operation from ending prematurely. If the restore
 operation is performed in a LAN free environment, this value
 must be specified for the Storage Agent.

And it is also documented in the following IBM Technote:

   http://www-1.ibm.com/support/docview.wss?uid=swg21114216

SQL Server backups are a stream of bytes. At restore time,
the SQL Server will ask for a very small amount of that
stream first. The SQL Server looks at the stream of bytes
to be able to know exactly how to rebuild that database.
The SQL Server then goes off and preformats the files
and whatever else it needs to do in order to restore
the remainder of the bytes. During this preformat time,
the TSM Server remains in SendW state.

I hope this helps.

Thanks,

Del




ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/04/2006
05:41:01 PM:

 We are also experiencing this same issue with the TDP SQL client.  We
 just restored a 41 GB database in about an hour and a half.  We
 previously had cancelled the restore several times because the session
 was in a SendW, and we thought it was hung.  Then it failed because it
 timed out after an hour.  I finally tried maxing out the commtimeout,
 and we just let it go.  The session remained in a SendW the entire time.
 Yet when it completed, all of the data had been transferred.  Is it
 normal for the session to remain in a SendW even while data is being
 transferred?

Re: TDP for SQL Large DB Restoration

[Weeks, Debbie]

This is great information, thanks!  We had found the information on the
commtimeout from some of your previous posts on another forum, but the
status of the session continued to throw us off track.  

Thanks again,

Debbie

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Del Hoobler
Sent: Wednesday, October 04, 2006 6:17 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP for SQL Large DB Restoration

This is expected behavior. This is documented in the DP/SQL User's
Guide:

   Note: When restoring large SQL databases, specifying a value of
 at least 1 in the commtimeout option will help prevent
 a restore operation from ending prematurely. If the restore
 operation is performed in a LAN free environment, this value
 must be specified for the Storage Agent.

And it is also documented in the following IBM Technote:

   http://www-1.ibm.com/support/docview.wss?uid=swg21114216

SQL Server backups are a stream of bytes. At restore time, the SQL
Server will ask for a very small amount of that stream first. The SQL
Server looks at the stream of bytes to be able to know exactly how to
rebuild that database.
The SQL Server then goes off and preformats the files and whatever else
it needs to do in order to restore the remainder of the bytes. During
this preformat time, the TSM Server remains in SendW state.

I hope this helps.

Thanks,

Del




ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/04/2006
05:41:01 PM:

 We are also experiencing this same issue with the TDP SQL client.  We 
 just restored a 41 GB database in about an hour and a half.  We 
 previously had cancelled the restore several times because the session

 was in a SendW, and we thought it was hung.  Then it failed because it

 timed out after an hour.  I finally tried maxing out the commtimeout, 
 and we just let it go.  The session remained in a SendW the entire
time.
 Yet when it completed, all of the data had been transferred.  Is it 
 normal for the session to remain in a SendW even while data is being 
 transferred?

Re: TDP for SQL - restoring to different server

[Del Hoobler]

Paul,

You will need the SQL Server on the alternate machine.
SQL Server backups are simply a stream of bytes.
They are not files, like Exchange, for example.
At restore time, Data Protection for SQL gives the
stream of bytes back to the SQL Server.
The SQL Server knows exactly how to put the databases
back together.

As for restoring an older backup with the command-line
client, yes... you will want to use the /OBJect= parameter.
Check the User's Guide for exact syntax.
Also check these IBM articles:
http://www-1.ibm.com/support/docview.wss?uid=swg21105967
http://www-1.ibm.com/support/docview.wss?uid=swg21168550

Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Corporation



ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/19/2006
01:30:20 AM:

 We have just started using TDP for SQL (version 5.2.1)

 I need to restore an SQL database backup from 7 days ago to another
 Windows server.

 I have a few questions regarding this.

 If I install TSM and TDP for SQL on another Windows server, does the
 server I restore it too have to have SQL installed on it? All I want to
 do initially is get the db file onto a server so that we can then move
 it to wherever we want.

 How do I specify the 7 day old database backup in the tdpsqlc command? I
 have run a tdpsqlc query on the original SQL server and I know what the
 database object name is of the database backup from 7 days ago.

 Regards
 Paul