> How to > Backup Utility > Regular SQL backup VS transaction log backup

Regular SQL backup VS transaction log backup

Posted on Nov 29, 2017 by Brithny to Backup Utility

Summary:
Regular SQL backup VS transaction log backup, free download SQL backup and recovery software: EaseUS Todo Backup Advanced Server to backup SQL Server.

Regular SQL backup

A regular SQL backup will allow for a full backup of your MS SQL Server and any selected databases to be performed. This is suitable for those who have databases which do not change in data.

Transaction log backup

Transaction log backups record any database changes. The benefit of a transaction log backup is that you can restore your MS SQL Server to a specific point in time during the day, reducing the amount of data or transaction loss you would incur. So it is good for anyone who has SQL databases which have a lot of data changing throughout the day and need to make sure they are able to recover as much data as possible. But please note the following facts about transaction log backup:

  • You should not back up a transaction log unless you have performed a full database backup at least once.
  • You cannot restore transaction logs without a corresponding database backup.
  • You cannot back up transaction logs when using the Simple Recovery model.

For example, you specify that you run your backups from 12 am to 10 pm Monday - Sunday. You also specify a 30 minutes interval in your backup.

A full backup of your MS SQL Server will be performed at 12 am. Then a transaction log backup will be performed every 30 minutes after this time, which backs up the transaction logs of your databases. These backups will continue until 10 pm. Then a final full backup of your MS SQL Server will be performed at 10 pm.