What the is the difference between performing a regular SQL backup and a Transaction Log backup, and what are the benefits for each?
Another frequently asked question fielded by the Helpdesk Team is about the uses of a SQL backup and a Transaction Log backup. It’s important to know the answer so you can make sure you’re covered in every data recovery scenario! SQL backups A regular SQL backup will allow for a daily full backup of your SQL server and any selected databases to be performed once a day, at a time that you choose. This is suitable for those who have databases which do not change in data by much on a daily basis and facilitates the full database or server to be restored. Transaction log backups A Transaction Log backup contains a lot more data. With a Transaction log backup, you will specify a backup window for the days you wish to perform your backups. You will then specify a time interval that you wish to have your backups run. For example, you could specify that you wish to have your backups run from 6am to 8pm Monday – Friday. You also specify a 15 minute interval in your backup. At 6am a full backup
