This has been one of those stupid questions keeping me awake at night. And while every DBMS that supports online backups probably works the same way, the smartest DBMS people I know are here.
Anyway, when I run an online backup of our ERP system database, what is really getting backed up? If I start my backup at 10pm, and the backup takes until 10:15pm, and the database is constantly being modified, is the resulting backup of the data from 10:15, 10pm, or somewhere in between?
Anyway, when I run an online backup of our ERP system database, what is really getting backed up? If I start my backup at 10pm, and the backup takes until 10:15pm, and the database is constantly being modified, is the resulting backup of the data from 10:15, 10pm, or somewhere in between?