Just wanted to get clarity on this matter for our DBA. We have SQL Databases that run full backups every couple of days, with Differentials running the additional days.
If i choose to restore the DB out of place, and i choose the date for the differential, do i still need to restore the full from the day before as well? or does this restore both at the same time with the differential and the last full?
Thanks
Best answer by Ron Potts
View original
+15
I could be wrong here so lets wait for the experts to share the correct answer, but my understanding is that you only need to select the DIFF that you want and the software will determine whether a most recent FULL needs to be pulled or not. In your case, since it is a out of place, it would restore the FULL and up until the DIFF you selected. That is the chain action mentioned below.
https://documentation.commvault.com/commvault/v11/article?p=18233.htm
Hello!
When you restore from a particular date or point in time, the Commvault software is intelligent in that it will look up the entire cycle or chain of backups that would be also required to restore the backup you are looking for. The restore will then (by default) restore the Full backup and any logs/differential backups required in that chain to ensure are restored up to the date/time specified.
So there would be no need to restore the Full or other backups manually first manually.
Thank you,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
