How can I be sure that if a failure occurs I will be able to restore
my database with the minimal loss?
Well this totally depends upon the Recover Point Objective (
RPO) and Recovery Time Objective (
RTO) as defined under business standards.So you need to have those details handy.
RPO here will be the data loss business willing to loose, mostly it will be very minimal. But lets say 15 mins ( in our case), so we have full backups followed by differentials and log backups every 10-15 mins (depending upon how critical the DB is).Therefore its very important that you should have a proper backup strategy in place in case there is a disaster and you need to recover back.
Next, concluding from above brings us to
RTO, which is the time you take to bring up the systems, or bring system back to healthy state, by performing those chains of operation from FULL, diff to log backups, depending upon the scenario.Therefore its important that you should have proper testing done to gather that time, not regularly but proactively to answer the business on
RTO. Again this is not technical but good to know as backup strategy.
Then followed by automating most of you're backup and restore, which should be easy in you're case as you are using third party tool.Also, you need to test and validate that your backups are working and that you can successfully
Some tips on testing here.
Just to add, in case backups are going to tape, it would be good practice to pull them up and check for healthy
restore to validate the backups sent to tape. Just to make sure on a safer side.