legato sql server backup

[Guest_imported]

Dear All,

We have recently upgraded the legato 6.0.1 from V5.5. The legato networker server is installed in Tru64 unix V.4.0.E.

We want to take the sql backup(both transaction log backup and full backup)with the following time sequence.

Transaction log to be taken for every 15 minutes and database full backup to be taken for every 1 hr.

Kindly provide us solution how to configure the sql server client for taking the transaction log backup and database backup in legato.

Thanks

regards
badri
kgb@sundaraminfotech.com

 

[ag100]

Hi,

A couple of things... You can do it, but depending on the way your environment is set up, you may not want such an aggresive schedule... Consider the time it will take to perform all backups before you decide on a schedule.

Assuming you still want to so this, simply create a group called something like "sqlbackups".. Then set it's interval time to 15 minutes, and create a cron job (see sample below) to switch the group level to full 5 minutes before the top of the hour, and incr 5 minutes after the hour. Then, create a client and make it a member of of that group. By having only 1 group to maintain, you're assured of having only 1 backup attempting to run at a time. There are other ways, but I think this is best for what you're looking for.

Good Luck!

-ag100

Sample cron job:

echo "print type:nsr group;name:sqlbackups" > /tmp/sample
echo "update level:full" >> /tmp/sample
nsradmin -s backup_server -i /tmp/sample > /tmp/switch_level.log