PPT-Lecture 10: Database recovery

Jose M Peña josempenaliuse 2 How can several users access and update the database at the same time Real world Model Database system Physical database Database management system. Saturday March 21, 2015 – Sunday April 05, 2015. 2. Plans Alpha and Bravo. Plan Alpha: . Recovery . of LEGACY . Database . in . NEW PROD Environment. (SMT . original preferred restore option). Pros. Dr. Alexandra Fedorova. Lecture . X. : . Transactions. Transactions. A transaction is a collection of actions logically belonging together. To the outside world, a transaction must appear as a . single indivisible operation. Backup and Recovery. Overview. Backup and recovery methods available in Oracle and SQL Server 2008. Types of failure. Types of recovery. Formulating backup and recovery strategies. Database Errors. The most common database errors include:. to . Dbvisit . Standby. Agenda. Introduction to Dbvisit Software. Disaster Recovery. Dbvisit Standby . Overview. Dbvisit Standby Demo. Q&. A. Dbvisit. Used in . 110. + Countries. Trusted by . 1000. for . SharePoint 2013. Brian Alderman. MCT / Consultant. MicroTechPoint. . SPC311. About the Speaker. Brian Alderman (CEO / Founder / MCT / Consultant). MicroTechPoint (MTP). www.microtechpoint.com. Introduction . Backup and recovery procedures protect your database against data loss and reconstruct the data, should loss occur. . The reconstructing of data is achieved through media recovery, which refers to the various operations involved in restoring, rolling forward, and rolling back a backup of database files.. Database Recovery. 1 Purpose of Database Recovery. To bring the database into the last consistent state, which existed prior to the failure.. To preserve transaction properties (Atomicity, Consistency, Isolation and Durability).. for non-DBAs. Anil Desai. SQL Saturday #35 (Dallas, TX). Anil Desai. Independent consultant (Austin, TX). Author of several SQL Server books. Instructor, “Implementing and Managing SQL Server 2005” (Keystone Learning). Some slides adapted from . Navathe. et. Al. , . Silberchatz. et. Al and Hector Garcia-Molina, . Dr. . Hao. -Hua Chu from NTU . Introduction and Basic Concepts. Purpose of Database Recovery. To bring the database into the last consistent state, which existed prior to the failure.. 1 Purpose of Database Recovery. To bring the database into the last consistent state, which existed prior to the failure.. To preserve transaction properties (Atomicity, Consistency, Isolation and Durability).. Introduction. Recovery algorithms. Recovery concepts. Write-ahead logging. In-place versus shadow updates. Rollback. Deferred update. Immediate update. Certain recovery techniques best used with specific concurrency control methods. modified from slides of . Lawrie. Brown. Databases. structured collection of data stored for use by one or more applications. contains the relationships between data items and groups of data items. Always On. Neil Hodgkinson. Senior Program Manager. Microsoft CXP CAT. SPc343. Neil Hodgkinson. Pre-Microsoft. Process . Chemist (Drugs. , Poisons . and Explosives. ). CSC SharePoint Specialist – 5 Years. Databases and SQL. Relational databases. relational . database. : A method of structuring data as tables associated to each other by shared attributes.. a . table row corresponds to a unit of data called a .