How to Recover from Media Failure

To recover user databases from media failure, find necessary information about lost devices and databases, re-create the lost devices in order, re-create the affected databases, and then restore those databases from backups. Anything done after the backups were created must be reapplied.

The procedure for restoring the master database is different. For details, see Restoring the master Database, later in this chapter.