Patent ID: 7650356
Filing Date: 2010-01-19
Classification: G06F

Abstract:
1. A system for generating an optimized restore plan for a database comprising: a restore advisor executing on a computer that presents to a user a plurality of restore scenarios, the plurality of restore scenarios being categorized by various events for which a restore plan is needed, each restore scenario describing characteristics of a type of database restoration desired, and the restore advisor further receives a selection from the user of one of said plurality of restore scenarios; wherein, in response to receiving the restore scenario selection, the restore advisor presents a series of prompts for identifying a source database, a target database, and a location of a backup history for the source database, wherein the source and target databases are each of a type in which transactions are performed against the database and a log of such database transactions is maintained; wherein, in response to receiving the source database, the target database, and the location of the backup history for the source database, the restore advisor automatically generates and presents to the user a first restore plan which specifies a plurality of backups to be applied and an order in which to apply the plurality of backups to satisfy requirements of the selected restore scenario; and wherein the first restore plan is presented as a list of steps wherein upon selection of a step, one or more step details may be viewed and a backup device specified for the step may be changed.