Incremental or differential backup: Which should you choose? In this article, we take a look at these two key concepts in backup, looking at the pros and cons of each, as well as point to resources ...

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...

Every good DBA understands that backing up their database data is a non-optional part of assuring data availability and integrity. As a DBA, you need to know the difference between a full image copy ...

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 ...

Backup and recovery done efficiently require use of multiple backup levels carefully thought out so a full backup isn’t needed as often if incremental and differential backups are properly planned.

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 ...

The purpose of backing up business-critical data is to achieve fast backups and restores that are 100% accurate. However, IT administrators have had to compromise between speed and accuracy because ...

In this discussion on incremental vs differential backup, we define the two terms using definitions that most people in the industry agree upon. There are complications in terminology, however, and we ...