What kind of backup are you using?

Over the years, full offline backups have been replaced with a combination of delta and incremental backups. Or, even use of disk snapshot technology for larger databases. So, if you are still taking down time for regular offline backups, think again. I have most of my clients set up for a combination of deltas, incrementals and possibly 1 full weekly backup. And the larger ones use write suspend and disk subsystem snapshot technology. Of course, the number one priority of a DBA is to make sure the data is always recoverable….That’s the view from here…..