User interface for piecemeal restore

In a computer system having a user interface and a selection device, a method for piecemeal restoration of a database, the method comprising:

• sending, in response to the occurrence of a specific event, a query to a database server application requesting a list of all offline files for the database;
• receiving the list of all offline files from the database server application;
• automatically presenting the list of all offline files on the user interface;
• receiving a list selection signal indicative of the selection device designating one or more of the files from the list;
• and
• in response to the receipt of the list selection signal, automatically formulating a command to bring the designated one or more files online with modified restore destinations.

In a computer system having a user interface and a selection device, a method for restarting piecemeal restoration of a database, the method comprising:

• receiving a restart selection signal indicative of the selection device designating a restart option on the user interface;
• in response to the receipt of the restart selection signal, sending a query to a database server application requesting a list of all filegroups for the database;
• receiving the list of all filegroups from the database server application;
• automatically presenting the list of all filegroups in place of a list of all offline filegroups on the user interface;
• receiving a list selection signal indicative of the selection device designating one or more of the filegroups from the list of all filegroups;
• and
• in response to the receipt of the list selection signal, automatically formulating a command to:
• take all online filegroups offline;
• and
• bring the designated one or more filegroups online.

In a computer system having a graphical user interface, a display, and a selection device, a method for piecemeal restoration of a database, the method comprising:

• automatically querying a database server application for a list of all offline filegroups for the database, in response to the initialization of the graphical user interface;
• receiving the list of all offline filegroups from the database server application;
• automatically displaying the list of offline filegroups on the display of the graphical user interface;
• receiving a list selection signal indicative of the selection device designating one or more of the filegroups from the list of all offline filegroups displayed on the graphical user interface;
• in response to the receipt of the list selection signal, automatically formulating a command to bring the designated one or more filegroup online;
• receiving an execute selection signal indicative of the selection device designating an execute option on the graphical user interface;
• and
• in response to the receipt of the execute selection signal, sending the command to the database server application;
• and
• receiving confirmation from the database server application that the command was executed and the designated one or more filegroups were brought online.