ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How Does Point-In-Time Recovery Work

Updated on June 22, 2011

Be ready when this happens

Point-in-time recovery explained

It can happen to anyone. Somehow your computer crashes and files show up as corrupted. If you were smart and made a backup of the database, then it’s possible to restore the computer to better times using a point-in-time recovery.

What is point-in-time recovery? In the big picture, it is a system in which a set of data can be restored to or recovered from a particular time in the past – sort of like a time machine for computers. This also works for a particular setting that needs to be reinserted. Windows XP and Vista both feature these capabilities as well as Time Machine for Mac OS X. The recovery is made to a specified date and time in which to restore the data base.

Point-in-time recovery works in certain systems by recording system file changes in order to restore to the previous points. These restore points can be done periodically, even daily by the program, or you can set up their own points. If a system failure occurs, then you can restore in either Safe Mode or Normal Mode, and recover system function. The system also records these points any time a new program is installed or a substantial change is made.

Some servers, such as Oracle perform crash recovery and instant recoveries automatically after a failure. There are two options: rolling forward the backup to a more current time by applying online re-do records or rolling back, in which changes are made to their original state. The Oracle system is very similar to the point in recovery systems mentioned above.

Most of the programs available are very simple to use and only prompt you for the date/time you need restored to. Sometimes it is necessary to perform several point-in-time recoveries to determine the exact time you need if you were not aware when the original corruption occurred, however this can be time consuming. The SQL Server provides instructions if you need to only restore certain databases. With SQL, there are three phases in the recovery and restoration that include data copy, redo (roll forward) and undo (roll back) phases. The data copy phase creates a copy of all the information backed up by the database previously and initialized the contents to be restored. The second phase, redo, takes the data and returns it to its original state at the recovery point or the date you specify. Lastly, the undo phase identifies uncommitted transactions which have become inconsistent with the recovered data. Once a consistency is established, the database is brought back to life.

Even with a point-in-time recovery system, it is still important to make a backup of your files regularly. The system restore is ideally meant for when the computer is corrupted or suffers some other catastrophe. With a backup, you still have important documents ready at hand. Most PC’s come with a disk providing a system restore program that can be installed at any time. With these disks it is important to remember that this process completely overwrites the files on your disk with any new files, rendering your old copy worthless. Having a previous backup will ensure that you still have the files you need.

P-I-T Survey

Does your company do backups that allow for point-in-time recovery?

See results


    0 of 8192 characters used
    Post Comment

    No comments yet.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)