Full Database Backups

Question

Full Database Backups

h.iddamalgoda 91897

Right there with Babe

Points: 797
More actions
March 28, 2019 at 3:45 am

#2033880

Hi
I have a 1.5TB database that takes 6-7 hours to backup.
At the end of the successful backup completion do we get a backup as at the point of start of backup or at the point of finish. In other words, are the changes that happen during the backup process (6-7 hours) captured or not.
Thank you
Hirantha

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

h.iddamalgoda 91897 - Thursday, March 28, 2019 3:45 AM
Hi
I have a 1.5TB database that takes 6-7 hours to backup.
At the end of the successful backup completion do we get a backup as at the point of start of backup or at the point of finish. In other words, are the changes that happen during the backup process (6-7 hours) captured or not.
Thank you
Hirantha

It's a backup at the point when it finishes. A full backup will contain any changes that happened during the backup itself.

Thanks

Gamleur84 Default port Points: 1475 More actions · Answer 2

NorthernSoul - Thursday, March 28, 2019 3:50 AM
h.iddamalgoda 91897 - Thursday, March 28, 2019 3:45 AM
Hi
I have a 1.5TB database that takes 6-7 hours to backup.
At the end of the successful backup completion do we get a backup as at the point of start of backup or at the point of finish. In other words, are the changes that happen during the backup process (6-7 hours) captured or not.
Thank you
Hirantha
It's a backup at the point when it finishes. A full backup will contain any changes that happened during the backup itself.
Thanks

I am curious though. What would happen if the server crashes in the middle of the full backup (after 4 hours for example). Then you last valid backup is at least 4 hours ago.

Can you still run transaction log backups while the full backup is in progress ?

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 3

Yes the transaction log backups will still run during a full backup and will give you a recovery point if the server crashes during the full backup. Obviously you would need to restore the last completed full backup and then apply the logs.

Thanks

h.iddamalgoda 91897 Right there with Babe Points: 797 More actions · Answer 4

NorthernSoul - Thursday, March 28, 2019 3:50 AM
h.iddamalgoda 91897 - Thursday, March 28, 2019 3:45 AM
Hi
I have a 1.5TB database that takes 6-7 hours to backup.
At the end of the successful backup completion do we get a backup as at the point of start of backup or at the point of finish. In other words, are the changes that happen during the backup process (6-7 hours) captured or not.
Thank you
Hirantha
It's a backup at the point when it finishes. A full backup will contain any changes that happened during the backup itself.
Thanks

Thank you.