Emc Corporation

Wenlu Ma

Aditya Kapoor

Craig G Duncan

Mu Chai

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.

Detecting failover in a database mirroring environment

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 tat which the most recent backup version in the list was created is determined. Next, a point in time tsubsequent to time tis identified. Finally, a command set that, when executed, functions to restore the database to the state that existed at time tis automatically formulated.

Point-in-time database restore

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.

Systems and methods for dynamic data backup

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.

Growing community of inventors

Sammamish, WA, United States of America

Wenlu Ma