• Wayne West (2/3/2015)


    My question would be what do the higher ups think is a good way do to backups? You don't need any extra money spent on additional software to do backups this way. Just make sure your backups can be restored to another database and that you're also properly doing transaction log backups.

    I think you hit it on the head: The only "good" backup is one that can be successfully restored within RTOs/RPOs. Personally, I began doing random point-in-time restores from the backups of our critical databases a couple of times a month.

    A side effect being that now I have pre-written SQL scripts for the process.

    ____________
    Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.