Modified representation of backup copy on restore
A method for database backup includes storing in a backup storage system a backup copy of a database comprising primary data records that are stored and accessed by clients in a primary storage system. In response to a first request made by a client to modify a specified record in the primary storage system, a modification rule is created. In response to a second request to restore to the primary storage system from the backup copy one or more of the data records in the database, including the specified record, the one or more of the data records are restored from the backup copy in the backup storage system to the database in the primary storage system while modifying the specified record in the data records restored to the database in the primary storage system in accordance with the modification rule, without modifying the backup copy of the database.
1 . A method for database backup, comprising:
storing in a backup storage system a backup copy of a database comprising primary data records that are stored and accessed by clients in a primary storage system;
in response to a first request made by a client to modify a specified record in the primary storage system, creating a modification rule with respect to the specified record for application to the backup copy;
receiving a second request, subsequent to the first request, to restore to the primary storage system from the backup copy one or more of the data records in the database, including the specified record; and
in response to the second request, restoring the one or more of the data records from the backup copy in the backup storage system to the database in the primary storage system while modifying the specified record in the data records restored to the database in the primary storage system in accordance with the modification rule, without modifying the backup copy of the database in the backup storage system.
2 . The method of claim 1 , wherein the modification rule causes content to be deleted from the specified record among the data records restored to the database.
3 . The method of claim 2 , wherein the modification rule causes one or more data fields to be blanked in the specified record among the data records restored to the database.
4 . The method of claim 1 , wherein the modification rule causes data to be replaced in the specified record among the data records restored to the database.
5 . The method of claim 4 , wherein the modification rule causes the data in the specified record to be replaced with an obfuscating character string.
6 . The method of claim 1 , wherein the modification rule causes the data in the specified record to be rectified in the data records restored to the database.
7 . The method of claim 1 , wherein the database is stored in the primary storage system in a native application format, while the backup copy is stored in the backup storage system in a backup format, different from the native application format, and wherein restoring the one or more of the data records comprises converting the one or more of the records from the backup format to the native application format and modifying the specified record in the native application format.
8 . The method of claim 1 , wherein the modification rule defines a search criterion, and wherein modifying the specified record comprises applying the search criterion to the one or more of the data records that are to be restored to identify the specified record for modification.
9 . The method of claim 8 , wherein the search criterion is applied to the backup copy as the one or more of the data records are restored or read from the backup copy and before the data records are restored to the database.
10 . The method of claim 8 , wherein the search criterion comprises one or more of a record identifier, an entity name, an entity mailing address, an entity electronic mail address, an entity telephone number, and an entity social security number.
11 . A computer software product, comprising a non-transitory computer-readable medium in which program instructions are stored, which instructions, when read by a computer, cause the computer to store in a backup storage system a backup copy of a database comprising primary data records that are stored and accessed by clients in a primary storage system, to create, in response to a first request made by a client to modify a specified record in the primary storage system, a modification rule with respect to the specified record for application to the backup copy, and in response to receiving a second request, subsequent to the first request, to restore to the primary storage system from the backup copy one or more of the data records in the database, including the specified record, to restore the one or more of the data records from the backup copy in the backup storage system to the database in the primary storage system while modifying the specified record in the data records restored to the database in the primary storage system in accordance with the modification rule, without modifying the backup copy of the database in the backup storage system.
12 . The product of claim 11 , wherein the modification rule causes content to be deleted from the specified record among the data records restored to the database.
13 . The product of claim 12 , wherein the modification rule causes one or more data fields to be blanked in the specified record among the data records restored to the database.
14 . The product of claim 11 , wherein the modification rule causes data to be replaced in the specified record among the data records restored to the database.
15 . The product of claim 14 , wherein the modification rule causes the data in the specified record to be replaced with an obfuscating character string.
16 . The product of claim 11 , wherein the modification rule causes the data in the specified record to be rectified in the data records restored to the database.
17 . The product of claim 11 , wherein the database is stored in the primary storage system in a native application format, while the backup copy is stored in the backup storage system in a backup format, different from the native application format, and wherein the instructions cause the computer to convert the one or more of the records from the backup format to the native application format and modify the specified record in the native application format.
18 . The product of claim 11 , wherein the modification rule defines a search criterion, and wherein the instructions cause the computer to apply the search criterion to the one or more of the data records that are to be restored to identify the specified record for modification.
19 . The product of claim 18 , wherein the search criterion is applied to the backup copy as the one or more of the data records are restored or read from the backup copy and before the data records are restored to the database.
20 . The product of claim 18 , wherein the search criterion comprises one or more of a record identifier, an entity name, an entity mailing address, an entity electronic mail address, an entity telephone number, and an entity social security number.
21 . Apparatus for data backup, comprising:
a backup storage device, which is configured to store a backup copy of a database comprising primary data records that are stored and accessed by clients in a primary storage system; and
a backup and recovery system, which is configured to create, in response to a first request made by a client to modify a specified record in the primary storage system, a modification rule with respect to the specified record for application to the backup copy, to receive a second request, subsequent to the first request, to restore to the primary storage system from the backup copy one or more of the data records in the database, including the specified record, and in response to the second request, to restore the one or more of the data records from the backup copy in the backup storage device to the database in the primary storage system while modifying the specified record in the data records restored to the database in the primary storage system in accordance with the modification rule, without modifying the backup copy of the database in the backup storage device.