• 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.

SQL 6.4 Clustered Environment - Scheduling

c.j.hund

ADSM.ORG Senior Member
Joined
Jun 22, 2005
Messages
247
Reaction score
3
Points
0
Website
Visit site
Hi all,

I am setting up SQL TDP 6.4 in a Windows 2012 environment. I followed the instructions found here to set up everything on the active side of the cluster:

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

I still need to failover to the other side of the cluster and finish my configuration/setup, but I don't anticipate any problems there. The one thing not discussed in the above link which you really need to know is how you schedule these backups after your configuration is complete.

I can run my backup scripts either locally or from the cluster's shared drive. How do you set up the schedule for these clusters? Do you create a cluster node and use that in place of the "LOCALDSMAGENT" on both sides of the cluster, or is this accomplished through the use of the /ALWAYSONNODE feature?

Sincere thanks,
C.J.
 

c.j.hund

ADSM.ORG Senior Member
Joined
Jun 22, 2005
Messages
247
Reaction score
3
Points
0
Website
Visit site
I think I may have made my question too complicated .... to put it more simply.

I have a clustered Win 2012 server environment, TDP version 6.4. How do you set up you dsm.opt and tdpsql.cfg files in this type of clustered environment? Do you specify a cluster node as the "DSM AGENT" node in the tdpsql.cfg file? Or, is it more like the new Exchange TDP where you run the backup (and schedules)versus both sides of the cluster and the passive side would complete it's schedule successfully? Is there any change at all with how you'd set up an SQL cluster in this 6.4 TDP?

Sincere thanks,
C.J.
 

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: 20 18.9%
  • Keep using TSM for Spectrum Protect.

    Votes: 64 60.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.3%
  • Other (please comement)

    Votes: 9 8.5%

Forum statistics

Threads
31,837
Messages
135,770
Members
21,788
Latest member
london
Top