The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...

Full-file incremental forever, block-level incremental forever or source depulication? The best way to choose is to perform backup and recovery tests and evaluate the performance of each method. A ...

Things break and the DBA must be prepared for situations where a failure impacts the availability, integrity, or usability of a database. Reacting to failures and service disruptions is a key ...

Backup is a fundamental protection required by any IT system. That’s all the more so in a world where ransomware attacks can take out company data in a stroke. Effective backup has also become more ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

It might be beneficial to "cryogenically" freeze a ransomware-infected hard drive until an encryption method is discovered down the road It's long been said that having a backup is the best way to ...

Last month we looked at various types of database recovery, how they work, and how DBAs need to prepare for recovery scenarios. This month, let’s delve a little deeper into the issues and decisions ...