Object Level Recovery

What Does Object Level Recovery Mean?

Object level recovery is a method of restoring individual database objects from a backup rather than the whole database. This is a feature of third-party products that makes restoring backups from relational databases much faster and easier than restoring a whole database in case some parts are accidentally deleted or corrupted.

Advertisements

Techopedia Explains Object Level Recovery

When part of a database is accidentally deleted or modified, usually the only thing that administrators can do is hope the wanted data was saved on a recent backup. With very large databases, restoring a few entries in a table from a backup can be an expensive proposition, in both storage space and time. An administrator needs enough disk space to unpack the backup and enough time to sift through it looking for the records that need to be copied over into the main database.

Object level recovery solves this problem by letting administrators pick out the exact objects they want from a database and use those for repair instead of a whole backup. Object level restore comes from third-party vendors who specialize in database backup and recovery.

Advertisements

Related Terms

Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.