Media failure occurs when someone accidentally deletes a database file from the file system.
For partitioned database systems, there should be a separate database file system on each machine that participates in the partitioned database.
Download the DB2 business game database file from the Downloads section of this tutorial.
Binary storage means that the database file can be smaller, and there is no requirement to translate data between different formats as data moves in and out of the database.
The most interesting scenario is to use SQL Compact Edition database file as a local cache of data that do not change often.
Offline backup is the backup of all the physical database files after a normal database shutdown.
