• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Clustered SQL backup - Always on Node?

okriss

ADSM.ORG Member
#1
Hello,

Can you explain me what the Always on Node means?
I have an sql cluster (win 2019-SQL 2017), with 10 instance. I would like to backup all instance on different name.
When i start the wizard, it asked me for the always on node...We did not set any mirroring between clusters. It is only a cluster.
I use 3 node for backup/instance...1st is the file level backup (e.g.:XXX-XXX), 2nd is the sql node which hold the sql db backups(xxx-xxx-SQL) and proxy node for the scheduler (which is proxy node for the SQL node - XXX-XXX-SQL-PROXY). Every config file are placed on the cluster disk which is belong to the instance. Schedulers are set. I have to run legacy backups!

If i ran the wizard and set everything (i think i have made some mistake ) i got error message :

Error: RC: 432
ACO0501E Invalid Proxy Configuration Detected: Target Node 'xxx-xxx-SQL' is not listed as a valid node to proxy to for Node Name 'XX-SQL02'.
At Get-DpSqlBackup -Private -Name * -AllTypes -COMPATibilityinfo -FROMSQLserver SQL-XX\<instance name> -QUERYNode DP -ConfigFile "C:\Program Files\Tivoli\tsm\TDPSql\tdpsql.cfg" -TsmOptFile "C:\Program Files\Tivoli\tsm\TDPSql\dsm.opt"
InvalidResult: (Capability.Impl....Sql.SqlContext:SqlContext) [Get-DpSqlBackup], Exception
432,IBM.Tivoli.TSM.Cmdlets.SQL.GetDpSqlBackup

xxx-xxx-SQL= node is the node which hold the SQL db backup
XX-SQL02= the cluster node which hold all instance (server)

Can you tell me how i should set this backup?....and the always on node...I have already read everything and saw all tsm video...

......"
If you are configuring Data Protection for SQL Server with SQL
Server 2012 or later versions, enter a node name in the AlwaysOn
Node field. This node name is used when the availability databases
are backed up in an AlwaysOn Availability Group."...

Thank you for your help!
 

okriss

ADSM.ORG Member
#2
Just on more thing...

If i want to set the parameters manually and dont run the wizards, i cannot see the instances in the FCM.
 

okriss

ADSM.ORG Member
#3
The 8.1.7 dp for db always need 'always on node' parameter, despite the mssql cluster did not configure for replication or AAG. (bug? or feature?) ...(The tdp 7.1 dont ask you for it if the db does not have replica)
If you set it with only config files, It will run perfectly!
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 16 18.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 52 61.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.8%
  • Other (please comement)

    Votes: 7 8.2%

Forum statistics

Threads
31,451
Messages
133,985
Members
21,549
Latest member
idhelmyy
Top