![]() ![]() For example use the following select command (all on one line): This solution includes using three scripts (one for Full, one for DiffFull, and one for Log) that perform backup actions at the desired scheduled intervals:Ī) Run a select against the sessions table to see if there is a backup session open for a given Data Protection for SQL node. Below are a couple of examples that can be used to schedule these three actionsġ) Scripting on the Tivoli Storage Manager Server. Every environment and their SLAs are different, but in most cases Full backups are performed once a day (or even once a week for large databases that can't perform full backups during the scheduled window), DiffFull backups (if used) periodically throughout the a day, and log backups every hour or so. Once the scripts are defined on the client, the next steps is to setup the scheduling. SQLLOG.CMD (to run 'tdpsqlc backup * LOG.') SQLDIFF.CMD (to run 'tdpsqlc backup * DIFF.' - Only required if performing differential backups) SQLFULL.CMD (to run 'tdpsqlc backup * FULL.') Regardless of which method below is utilized, 3 separate scripts will need to exist on the client (the names may vary). There are multiple methods that can minimize the chance of missed backups for a particular node, but below are 2 possible methods. When scheduling Full, Differential, and Log backups to run multiple times throughout the day, one can run into the issue of log backups being missed because the Full or DiffFull is still running. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |