[prev in list] [next in list] [prev in thread] [next in thread] 

List:       adsm-l
Subject:    Re: Antwort: [ADSM-L] using TDP-SQL w/o proxy relationships?
From:       "Schaub, Steve" <Steve_Schaub () BCBST ! COM>
Date:       2017-04-14 17:49:23
Message-ID: 3DDDE240913B014E995746F31DBEB55F5B93BA7B () bcmsg103 ! bcbst ! com
[Download RAW message or body]

Thanks, Markus.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Markus \
                Stumpf
Sent: Friday, April 14, 2017 10:09 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Antwort: [ADSM-L] using TDP-SQL w/o proxy relationships?

Hi Steve,


There are 2 kind of proxy relations possible in DP for SQL.

The Proxy relations required to perform VSS backups:
local dsmagent needs to be granted permission to dp node.

and in case you use always On configuration:
dp node needs access to the "virtual" AlwaysOn node


If you do not want to run VSS style backups you need to set your backupmethod to \
legacy in tdpsql.cfg file or better: Run the TSM configuration wizard inside the MMC \
and enable the tick: Do not configure VSS backups (not 100% sure, this is the correct \
wording, but it is on the wizard page, where you define your node names)

In this case no proxy relations between local dsm agent and dp node are needed.


Your problem here is, that your AlwaysOn Node has the same name as your DP Node \
(Nodename in dsm.opt of tdpsql).

In case you want to backup AlwaysOn enabled databases you need to configure proxy \
relations between each DP Node (ussually a minimum of 2 SQL Server participate on the \
AlwaysOn configuration) two the virtual always ON node.

For example:

AlwaysOn Node: AAInstance1
SQL Servers: SQL1 and SQL2 (having baclient nodes SQL1 and SQL2 and DP nodes  \
SQL1_SQL and SQL2_SQL)

you need for legacy only config:
grant proxy agent=SQL1_SQL target=AAInstance1 grant proxy agent=SQL2_SQL \
target=AAInstance1


To configure both legacy and VSS the complete list of proxy relations is:
grant proxy agent=SQL1_SQL target=AAInstance1 grant proxy agent=SQL2_SQL \
target=AAInstance1 grant proxy agent=SQL1 target=AAInstance1 grant proxy agent=SQL2 \
target=AAInstance1 grant proxy agent=SQL1 target=SQL1_SQL grant proxy agent=SQL2 \
target=SQL2_SQL

You can also use the TSM Configuration wizard to configure the proxy relations on the \
TSM Server by enabling TSM configuration in the wizard and edit the macro file. You \
can pick all required proxy relations from the macro file and skip the not needed \
definitions for domain, policies and so on if those already exist.

Best regards
Markus Stumpf
----------------------------------------------------------------------------

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


[prev in list] [next in list] [prev in thread] [next in thread]