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

TDPSQL 15 min backup issue

Damon_Silk

ADSM.ORG Member
#1
Hi there,

I have an issue with 15 min SQL Log backups and the TSM Scheduler that I'd like help with please.

I'm trying to set this up from scratch. I am using Legacy backups.

I have set up 5 client schedules, 4 for each 15 min log backups - on the hour, the quarter hour, half hour and 3 quarter hour. And then a separate one for the full backup.

The symptom I am seeing is the full backup seems to take about an hour and during that time, the 15 min log backup schedules become "missed'. I suspect it's to do with the fact that as the full backup is still running, the client scheduler hasn't refreshed/updated the schedule and picked up the other 15 min schedules (log backups). Is this feasible? If so, how do I fix it please :)

In the (client) log file outputs for the SQL Log backups you see no entries for the duration for the full backup, so it's not even attempting to run it at all. There's nothing in the dsmerror.log files either.

I have tested manually running the full backups and log backups at the same time and that's fine. So it's not an issue with the 2 running at the same time.

Any help/guidance would be appreciated. Cheers,

Damon
 

Trident

TSM noob with 10 years expirience
ADSM.ORG Moderator
#2
Hi,

We use two node_names to handle sql servers with log and full backup.

One node does log backup, and the other does full backup. The schedule just starts a cmd file for full/log respectivly. Both cmd files use the same opt file, so all backup ends up on the same storage node

With that config, the log and full does not interfere with each other.
 

Damon_Silk

ADSM.ORG Member
#3
Hi there Trident, thanks for this - sounds like a good option :). One question though, when you say you use 2 nodenames but reference the same opt file - how is this possible? i.e. the nodename goes into the optfile, so can you have multiple nodenames specified in the optfile? If not, how do you use 1 optfile but 2 nodes? Didn;t know you could do that :-(
 

Trident

TSM noob with 10 years expirience
ADSM.ORG Moderator
#4
SQL node = server_mssql (dsm.opt)
Log Sched Node = server_mssql_log (log.opt)
Full Sched Node = server_mssql_full(full.opt)

Make two tsm schedule processes using the log and full nodename and respectibe opt files.

These two schedules starts a command

Log -> sql_log.cmd
Full -> sql_full.cmd

Both these filees will use dsm.opt . You start tdpsqlc backup XXX full|log /tsmoptile=dsm.opt

There are other options here, but this is simple and straight forward.
 

Damon_Silk

ADSM.ORG Member
#6
1 (well maybe 2 :) ) more question please. Firstly, looks like it's working well so thanks again for that.

My question is though:-

Which node should the data be stored in, in TSM now then? The "server_mssql_log" and "server_mssql_full" nodes or the original node, i.e. "server_mssql" in your example above?

Also, from a policy association perspective, should the original nodename (server_mssql in this example) still be assigned to a client schedule, or should that be removed?

Cheers,

Damon
 

Trident

TSM noob with 10 years expirience
ADSM.ORG Moderator
#7
Hi,
In my sample, all data should be stored in server_mssql, and it should not be assigned any schedules. Only nodes with schedules are the *log and *full nodes.
 

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,448
Messages
133,969
Members
21,548
Latest member
cburns
Top