What is the mechanism that allows the database to be backed up online. What happens if the server goes down in the middle of a backup with many open transactions?
Continuous Operations allows you to put a setup of data files in a special “mode” so that they can be safely backed up while in use. While files are in continuous operations mode, they are not modified, and special delta files store any changes made to the files. After the backup is complete, the files must be removed from continuous operations mode, at which time the changes stored in the delta file are rolled into the live files. If the server goes down while files are in continuous operations mode, the next time the file is accessed the existing delta file will be detected and the changes rolled in at that time.
