The oldest type of backup, often inconsistent, simply copies data from beginning to end, risking inconsistency if modifications occur during the process.
Crash-consistent backups capture all data at one time but miss in-memory transactions, returning a system state equivalent to the moment of crash.
Application-consistent backups offer the highest protection, ensuring data consistency by capturing the entire application state, including all ongoing transactions.
For SQL Server, understanding the different file types (MDF, NDF, LDF) is key, as they influence the backup strategy and overall data integrity.
Collection
[
|
...
]