Restore Damaged Files from File Backups

A few database volumes are damaged and must be restored, but the server is functional and other databases remain available. Available backups consist of a full set of file/filegroup snapshot backups and a set of conventional transaction log backups. Database recovery requires restore of the snapshots of the damaged volumes followed by application of the transaction log backups.

Note   This scenario is not possible if the snapshot technology does not allow mounting of the volumes during the execution of the RESTORE statement.

Steps

• For each damaged volume {

  Restore file/filegroup snapshot with NORECOVERY.

  }

• Apply conventional log backups and recover.