Abstract: In one example, a method for detecting failover in a database mirroring system that begins when a determination is made as to the time of the most recent backup of the principal database. Next, the time of the most recent backup of the mirror database is determined. Then, the time of the most recent backup of the principal database is compared to the time of the most recent backup of the mirror database to determine if the principal database was backed up most recently. Finally, if the mirror database is the database that was backed up most recently, it is established that failover has occurred.

Abstract: This disclosure concerns systems and methods for restoring data. In one example, a method for restoring a database to a particular state begins when a query is sent to a backup server requesting a list of all backup versions for the database. Next, the list of all backup versions is received from the backup server. Then, the time t0 at which the most recent backup version in the list was created is determined. Next, a point in time t2 subsequent to time t0 is identified. Finally, a command set that, when executed, functions to restore the database to the state that existed at time t2 is automatically formulated.

Abstract: In a computer network that includes database mirroring, a first database is located on a first database server and a second database is located on a second database server and, optionally, a witness database server. One of the first database or the second database is a live database while the other database is the mirror database. A process is initiated for communicating with the first database server, the second database server, or the witness database server, to determine which of the first database or the second database is the live database. The location of the live database is determined by reading information from the table entries in system databases on either the first or second database servers, or the optional witness database server, and a backup operation is performed wherein the live database is backed up.

Abstract: In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

Abstract: This disclosure concerns systems and methods for restoring data. In one example, a method for restoring a database to a particular state begins when a query is sent to a backup server requesting a list of all backup versions for the database. Next, the list of all backup versions is received from the backup server. Then, the time t0 at which the most recent backup version in the list was created is determined. Next, a point in time t2 subsequent to time t0 is identified. Finally, a command set that, when executed, functions to restore the database to the state that existed at time t2 is automatically formulated.

Abstract: In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

Abstract: This disclosure concerns systems and methods for restoring data. In one example, a method for piecemeal restoration of a database involves a computer system having a user interface and a selection device. The method begins when a query is sent to a database server application requesting a list of all offline filegroups for the database. Next, the list of all offline filegroups is received from the database server application. Then, the list of all offline filegroups is automatically presented on the user interface. Next, a list selection signal is received, indicative of the selection device designating one or more of the filegroups from the list. Finally, in response to the receipt of the list selection signal, a command is automatically formulated to bring the designated one or more filegroups online.

Abstract: This disclosure is concerned with systems and methods for backing up data. In one example, a method for detecting failover in a database mirroring system that begins when a determination is made as to the time of the most recent backup of the principal database. Next, the time of the most recent backup of the mirror database is determined. Then, the time of the most recent backup of the principal database is compared to the time of the most recent backup of the mirror database to determine if the principal database was backed up most recently. Finally, if the mirror database is the database that was backed up most recently, it is established that failover has occurred.

Abstract: In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

Abstract: In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

Abstract: In a computer network that includes database mirroring, a first database is located on a first database server and a second database is located on a second database server and, optionally, a witness database server. One of the first database or the second database is a live database while the other database is the mirror database. A process is initiated for communicating with the first database server, the second database server, or the witness database server, to determine which of the first database or the second database is the live database. The location of the live database is determined by reading information from the table entries in system databases on either the first or second database servers, or the optional witness database server, and a backup operation is performed wherein the live database is backed up.