Three SQL Server Backup Types

Brithny updated on Sep 12, 2019 to Backup Utility | How-to Articles

Full backup

A full backup contains all the data in a specific database or set of file groups or files, and also enough log to allow for recovering that data. It is the base of both differential backup and transaction log backup.

Differential backup

A differential backup is not independent and it must be based on the latest full backup of the data. That means there should have a full backup as a base. A differential backup contains only the data that has changed since the differential base. Typically, differential backups are smaller and faster to create than the base of a full backup and also require less disk space to store backup images.

Therefore, using differential backups can save available space and speed up the process of making frequent backups to decrease the risk of data loss. At restore time, the full backup is restored first, followed by the most recent differential backup.

Remember not to rely on only one base, create several bases of differential backup at different times to guarantee the backup files' security.

Transaction Log Backups

The transaction log is a serial record of all the transactions that have been performed against the database since the transaction log was last backed up. With transaction log backups, you can recover the database to a specific point in time (for example, prior to entering unwanted data), or to the point of failure.

The transaction log backups are only valuable under the full recovery model or bulk-logged recovery model. Each log backup covers the part of the transaction log that was active when the backup was created, and it includes all log records that were not backed up in a previous log backup. An uninterrupted sequence of log backups contains the complete log chain of the database, which is said to be unbroken. Under the full recovery model, and sometimes under the bulk-logged recovery model, an unbroken log chain lets you restore the database to any point in time.

Just like differential backup, transaction log backup is also based on a full backup. Therefore, before you can create the first log backup, you must create a full backup, such as a database backup. Because it requires less disk space than a full backup, you can create them more frequently than database backups.

Free download SQL backup and recovery software and back up SQL Server with different SQL backup types, refer to more detailed functions and solutions for SQL backup and recovery, see EaseUS Todo Backup Advanced Server

Backup SQL Server Database

 
 

100% of people found this article helpful.

 

Frequently Asked Questions

Why choose EaseUS Todo Backup?

"The easiest way to protect your data and system files."techradar

"EaseUS Todo Backup Free is one of the most popular free data backup applications available. This software offers a myriad of features and is extremely user-friendly. It provides a full system backup, meaning you can back up your entire operating system."TopTenReviews

"EaseUS ToDo Backup Home is a great backup program, well suited to the home and SMB space."PCWorld

What is the difference between Clone and Backup? In what cases should I use Clone?

Clone will copy one disk to another or one partition to another (unallocated space is also supported). Usually, this option is used to upgrade the current disk by creating an identical copy. Backup will generate a .PBD image file containing the selected files or system that can be restored from the .PBD image if needed.

What is the difference between System Backup and Disk Backup?

System Backup will auto-select the system boot related partition(s) as the backup source to make sure the system image can be restored properly. Disk/Partition Backup will allow you to manually select a whole disk or speficy a certain partition as the backup source. You will get the same backup result as System Backup if you manually select the system and boot partitions with the Disk/Partition Backup option.

As a computer newbie, what features should I use to protect my computer?

You can use System Backup to back up the system and boot partitions, use Disk/Partition backup to back up the data partition and add plans to run an automatic backup. If you use the computer frequently or have software that may cause boot failure of the computer, we would suggest you back up the computer every 1 to 2 days. For other situations, you can backup the computer once a week. In addition, you can schedule File Backup to back up the files which are changed frequently.

What kind of storage service should I use to save my backup images?

EaseUS Todo Backup can save backup images to internal disks, external disks, network drives, or free cloud(Google Drive, Dropbox, and OneDrive) and CD/DVD. It is suggested to save the images to the internal/external/network drives to save time as those kinds of disks have a better read-write speed. It is suggested NOT to save the image on the source disk, because once the disk is damaged, all the files on the disk will become unavailable and you will be unable to restore the image.

As a company network administrator, what features should I use to protect our internal computers?

It is recommended that you use the SQL Backup feature to back up your company's SQL server and Exchange Backup feature to back up the Exchange server. In addition, you can execute System Backup to back up the system and boot partitions on every computer and set a plan to execute the backup once a day or twice a week to ensure that the computer can be restored timely when it has boot issues. File Backup feature can be used to back up important user data. If there are a large quantity of computers, you can purchase EaseUS Backup Center to manage the backups on the client computers centrally.

About EaseUS Todo Backup

Be it a file, system, partition, or disk, EaseUS Todo Backup will help you back up or clone the item and provide you with multiple backup plans.