SQL Restores View Only Latest Full and Dif

Last post 02-20-2019, 3:20 PM by jszutarski. 1 replies.
Sort Posts: Previous Next
  • SQL Restores View Only Latest Full and Dif
    Posted: 02-19-2019, 4:10 PM

    So, this isnt necessarily an issue, but during the restore process for a SQL DB, once you select the DB and click "recover all selected items" , SQL Restore Options pops up and it only shows me the latest FULL and latest Dif in the restore time field. How do I see all the available fulls and difs in that list? Is there a reg key I can add to make it visible?



  • Re: SQL Restores View Only Latest Full and Dif
    Posted: 02-20-2019, 3:20 PM


    What you're seeing is most likely dependent on how you are browsing


    Factors in Choosing the Appropriate Restore Methods and Options

    When you select a restore time, the software determines the optimal combination of full backup, differential backup, and log backups necessary to bring the restored databases back to the selected time. This combination of backups is called the restore chain.

    • For basic database restores, the restore chain consists of the most recent full backup, the latest differential backup (if any), and all the subsequent log backups (if any) taken prior to the selected restore time.
    • While restoring databases to a transaction mark or during a point-in-time restore, the restore chain consists of the most recent full backup, the latest differential backup (if any), all the subsequent log backups taken prior to the selected browse time, and the next log backup after the browse time. The transparent inclusion enables restores to a selected point in time.


    Do you need to restore data from the latest available backup data or from a previous point in time?

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy