Understanding backups

To understand what files you need to back up, and how you restore databases from backups, you need to understand how the changes made to the database are stored on disk.


The database file
The transaction log
Protecting your data against media failure