Automated backup and restore of a disk group

A computing system for restoring a clustered database with near zero downtime, the computing system comprising:

• a processor;
• and
• a memory coupled to the processor and including computer-readable instructions that, when executed by the processor, cause the processor to:
• receive a request to restore a backup image of a failed shared storage device to a specified time, the failed shared storage device being associated with the clustered database, the clustered database including a plurality of nodes, each of the plurality of nodes including database data from the failed shared storage device;
• perform a preflight check on a plurality of nodes of the clustered database, the preflight check comprising performing at least one checklist process including at least one of:
• validating a user associated with the request to restore the clustered database,
• checking a location of software associated with performing the requested restore,
• checking whether requisite software is running, and
• checking whether the clustered database is running;
• associate each performed checklist process of the at least one checklist process with one of a pass status and a fail status, the pass status indicating that the performed checklist process passed and the fail status indicating that the performed checklist process failed;
• when a performed checklist process of the at least one checklist process is associated with a fail status, terminate the restore;
• and
• when each performed process of the at least one checklist process is associated with a pass status, complete the restore, wherein completing the restore comprises:
• creating at least one flashcopy associated with the backup image;
• mapping to each of the plurality of nodes an associated portion of the at least one flashcopy such that the at least one flashcopy is accessible as a diskgroup by each of the plurality of nodes, thereby restoring clustered databases with near zero downtime.

A non-transitory computer readable medium having executable instructions operable to cause an apparatus to:

• receive a request to restore a backup image of a failed shared storage device to a specified time, the failed shared storage device being associated with a clustered database, the clustered database including a plurality of nodes, each of the plurality of nodes including database data from the failed shared storage device;
• perform a preflight check on a plurality of nodes of the clustered database, the preflight check comprising performing at least one checklist process including at least one of:
• validating a user associated with the request to restore the clustered database,
• checking a location of software associated with performing the requested restore,
• checking whether requisite software is running, and
• checking whether the clustered database is running;
• associate each performed checklist process of the at least one checklist process with one of a pass status and a fail status, the pass status indicating that the performed checklist process passed and the fail status indicating that the performed checklist process failed;
• when a performed checklist process of the at least one checklist process is associated with a fail status, terminate the restore;
• and
• when each performed process of the at least one checklist process is associated with a pass status, complete the restore, wherein completing the restore comprises:
• creating at least one flashcopy associated with the backup image;
• mapping to each of the plurality of nodes an associated portion of the at least one flashcopy such that the at least one flashcopy is accessible as a diskgroup by each of the plurality of nodes, thereby restoring clustered databases with near zero downtime.