Unless a database device is mirrored, full recovery requires that a database’s transaction log be stored on a different device from the actual data (including indexes) of a database. In the event of a hard disk crash, you can create an up-to-date database by loading a dump of the database and then applying the log records that were safely stored on another device. See Chapter 21, “Creating and Managing User Databases,” for information about the log on clause of create database.
