November 26, 2013 at 7:25 am
Good day, I need to work on a script that will run a tivoli log backup based on one of the database input. I need to create 1 job that will run every hour and look at that database and do a backup according to a data we put in (1h,2h,4h) some db needs to be backed up every 1h, 2h,and 4h. What could be a good apporach, where to start with this project. Thank you
November 26, 2013 at 7:31 am
I wouldn't reinvent the wheel. I would use Ola Hallengren's back scripts:
As far as the how often to run them I would create jobs based on the schedules for the different database (1h, 2h, etc.). If it needs to be more dynamic (why?) you can create an SSIS package that is data driven to accomplish this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply