ATE463797T1 - DATABASE DATA RECOVERY SYSTEM AND METHOD - Google Patents

DATABASE DATA RECOVERY SYSTEM AND METHOD

Info

Publication number
ATE463797T1
ATE463797T1 AT04779217T AT04779217T ATE463797T1 AT E463797 T1 ATE463797 T1 AT E463797T1 AT 04779217 T AT04779217 T AT 04779217T AT 04779217 T AT04779217 T AT 04779217T AT E463797 T1 ATE463797 T1 AT E463797T1
Authority
AT
Austria
Prior art keywords
database
snapshot
data
error
files
Prior art date
Application number
AT04779217T
Other languages
German (de)
Inventor
Michael Zwilling
Gregory Smith
Rajeev Rajan
Jakub Kulesza
Peter Byrne
Shashikant Khandelwal
Mark Wistrom
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from US10/833,541 external-priority patent/US8095511B2/en
Application filed by Microsoft Corp filed Critical Microsoft Corp
Application granted granted Critical
Publication of ATE463797T1 publication Critical patent/ATE463797T1/en

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to a system and method of data restoration, for instance, after the occurrence of a user error. In particular, snapshot database can be maintained that stores a copy of database data. The snapshot database does not have to store a complete copy of all data on a source database, but rather shares data that is common to both but not necessarily identical. If an error occurs on the primary database then the database can be reverted back to a point in time prior to the error by replacing source database files with snapshot files. Additionally, an undo component can be employed in conjunction with the snapshot to approach an error to a finer grained point in time. In brief, the present invention can restore a database much faster and simpler, while utilizing less space and resources than conventional data restoration technologies.
AT04779217T 2004-02-25 2004-07-27 DATABASE DATA RECOVERY SYSTEM AND METHOD ATE463797T1 (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US54764104P 2004-02-25 2004-02-25
US10/833,541 US8095511B2 (en) 2003-06-30 2004-04-28 Database data recovery system and method
PCT/US2004/024048 WO2005086032A1 (en) 2004-02-25 2004-07-27 Database data recovery system and method

Publications (1)

Publication Number Publication Date
ATE463797T1 true ATE463797T1 (en) 2010-04-15

Family

ID=36773857

Family Applications (1)

Application Number Title Priority Date Filing Date
AT04779217T ATE463797T1 (en) 2004-02-25 2004-07-27 DATABASE DATA RECOVERY SYSTEM AND METHOD

Country Status (3)

Country Link
CN (1) CN1784676B (en)
AT (1) ATE463797T1 (en)
DE (1) DE602004026422D1 (en)

Families Citing this family (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8112664B2 (en) * 2008-03-26 2012-02-07 Symantec Operating Corporation Using volume snapshots to prevent file corruption in failed restore operations
US8412676B2 (en) * 2008-10-21 2013-04-02 Microsoft Corporation Forgetting items with knowledge based synchronization
CN102685733B (en) * 2012-04-27 2016-08-03 王兰睿 A kind of method and system for creating and safeguard mobile station information mirror database
CN103870478B (en) * 2012-12-12 2018-09-25 腾讯科技（深圳）有限公司 A kind of method and device for restoring synchrodata
CN103914359B (en) * 2012-12-31 2017-09-26 中国移动通信集团浙江有限公司 A kind of data reconstruction method and device
US9589008B2 (en) * 2013-01-10 2017-03-07 Pure Storage, Inc. Deduplication of volume regions
GB2509930A (en) * 2013-01-17 2014-07-23 Ibm Data backup recovery
US9501501B2 (en) 2013-03-15 2016-11-22 Amazon Technologies, Inc. Log record management
US9514007B2 (en) 2013-03-15 2016-12-06 Amazon Technologies, Inc. Database system with database engine and separate distributed storage service
CN104156369B (en) * 2013-05-14 2019-04-02 上海盛大网络发展有限公司 A kind of database mirroring production method and a kind of database
US9098453B2 (en) * 2013-07-11 2015-08-04 International Business Machines Corporation Speculative recovery using storage snapshot in a clustered database
CN105677673B (en) * 2014-11-20 2019-01-04 阿里巴巴集团控股有限公司 Method for processing business, apparatus and system
CN104462342B (en) * 2014-12-04 2018-08-07 北京国双科技有限公司 database snapshot synchronization processing method and device
EP3234771A4 (en) * 2014-12-18 2018-07-25 Intel Corporation Translation cache closure and persistent snapshot in dynamic code generating system software
US10884869B2 (en) * 2015-04-16 2021-01-05 Nuodb, Inc. Backup and restore in a distributed database utilizing consistent database snapshots
US10180954B2 (en) 2015-05-29 2019-01-15 Nuodb, Inc. Disconnected operation within distributed database systems
US10496672B2 (en) 2015-12-30 2019-12-03 EMC IP Holding Company LLC Creating replicas at user-defined points in time
CN107239365B (en) * 2016-03-29 2020-11-27 华为技术有限公司 Method and device for accessing storage equipment
CN106708662A (en) * 2016-12-13 2017-05-24 上海上讯信息技术股份有限公司 Method for restoring database and equipment
TWI735518B (en) * 2017-01-24 2021-08-11 香港商阿里巴巴集團服務有限公司 Service provision method and system of database
CN107203345B (en) * 2017-06-01 2019-10-01 深圳市云舒网络技术有限公司 A kind of more copies storage rapid verification coherence method and its device
CN111414370A (en) * 2019-01-07 2020-07-14 北京智融网络科技有限公司 Feature library updating method and system

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6065018A (en) * 1998-03-04 2000-05-16 International Business Machines Corporation Synchronizing recovery log having time stamp to a remote site for disaster recovery of a primary database having related hierarchial and relational databases
US6438749B1 (en) * 1999-03-03 2002-08-20 Microsoft Corporation Method and system for restoring a computer to its original state after an unsuccessful patch installation attempt

Also Published As

Publication number Publication date
DE602004026422D1 (en) 2010-05-20
CN1784676A (en) 2006-06-07
CN1784676B (en) 2012-05-30

Similar Documents

Publication Publication Date Title
ATE463797T1 (en) DATABASE DATA RECOVERY SYSTEM AND METHOD
MXPA05009680A (en) Method and system for synthetic backup and restore.
US10353781B2 (en) File corruption recovery in concurrent data protection
US9152500B1 (en) Hash collision recovery in a deduplication vault
CN105446828B (en) A kind of DB Backup, restoration methods, apparatus and system
US9626518B2 (en) Avoiding encryption in a deduplication storage
JP2007524173A5 (en)
ATE470903T1 (en) PROVIDING A SNAPSHOT OF A SUBSET OF A FILE SYSTEM
JP2006092553A5 (en)
CN105843707B (en) Database quick recovery method and equipment
US9430272B2 (en) Efficiently providing virtual machine reference points
WO2007021443A3 (en) Online page restore from a database mirror
MY141354A (en) Device, method and computer program to avoid data corruption during writing operations
TW200707226A (en) Method, system and article of manufacture for metadata replication and restoration
GB2530958A (en) Replication for on-line hot-standby database
RU2008147124A (en) EFFECTIVE CREATION OF FREQUENCY BACKUP COPIES INTEGRATED FOR APPLICATIONS
WO2006127404A3 (en) Method and apparatus for storage backup
CN102609337A (en) Rapid data recovery method for memory database
US8732418B1 (en) Shadow registry
WO2007111751A3 (en) Architecture for a smart enterprise framework and methods thereof
US20190138386A1 (en) Recovering log-structured filesystems from physical replicas
CN104850628A (en) Data synchronization method and apparatus in database
US8639660B1 (en) Method and apparatus for creating a database replica
SA522431555B1 (en) Securing Database Backups With Unique Global Identifier
CN105653718A (en) Method for ensuring database data consistency after snapshot in storage disk snapshot environment

Legal Events

Date Code Title Description
RER Ceased as to paragraph 5 lit. 3 law introducing patent treaties