How to skip 2h in every 15min backup schedule?

[quater]

I have this kind of request from my SQl admin (NW 7.5.1):
- Full database backup every night at 02:00am
- Transaction log (or xlog or incr) backup at every 15min

The full database backup takes for about 1.5h.

My question is: is there any elegant way to tell my SQL group to skip every 15min xlog backup from 02:00am to 04:00am? For that period of time I'll do full backup.

Thnx

 

[denisfr]

Hello,

the only way I see is to schedule a savegrp with crontab and not let NW to run group automatically.

Denis

 

[quater]

Thank you denisfr, but I need to get resolution through NW. The only thing I could do for now (I had very short time for resolution) is to put 1 client in 20 (!) groups, each with different start time and interval.

This solution is working but I'm looking for something more elegant...and simpler. One day, when backup requests change, I will have a lot to change...and when add two more SQL servers...lot of work! Lot of copy

Perhaps try with probing...?

 

[denisfr]

...or you can consider a cron job that disable the client (like unchecking the 'scheduled backup' in the GUI) for the group via a nsradmin command, but it is not a 'full NW solution' (which does not exists, I'm afraid of it)...