Discover the granular SQL multi-database restore capabilities introduced in PowerProtect Data Manager 20.2. This update allows administrators to select specific backup copies for individual databases, integrating full, differential, and log backups seamlessly. Users gain exact point-in-time restores through timestamp-based selection, providing greater flexibility, control, and accuracy during recovery operations. Watch the demonstration to see how these enhancements simplify the restore process and align targeted recovery with specific business needs.
Hello everyone with PowerProtect Data Manager 20.2 we have introduced granular SQL multi Database Restore with copy selection and timestamp based recovery. This enhancement enables users to select specific backup copies per database, including full differential and log backups, perform precise point in time restores using timestamp based selection. Achieve greater flexibility, control, and accuracy during recovery operations.
Together, these capabilities simplify restores while allowing more targeted recovery aligned to business needs. Let's now take a look at this in action. So this is my Data Manager version 20.1. So I have already backed up the SQL databases on the restore operation. So I'm selecting both the database instance assets.
Click on restore. So by default the restore operation uses the latest copy. And this is my Data Manager version 20.2. So I've already backed up the SQL databases. So if I go to the restore operations. So select both the assets and click on restore. So you can see that we have the option to select the copies. So by default it will use the most recent copy. And for particular instance if you wanted to change a copy you can select the asset and you can click on Change Copy. From this list you can select the required version.
And you can click on okay to select that particular copy. So for this instance I have changed the copy version. And similarly I'm changing the copy for the other instance as well. So now you can have the ability to select the version and click on next as usual to perform the restore. And then we also have the other option so we can select the copies from an earlier point in time using the time stamps. So I'm just selecting the date.
The time. So I have done the backups like 8:37 a.m.. That particular time and the storage system. Click on apply. So below we can see the asset backup copies that match the selection criteria. We can also choose a different copy. So to choose a different copy select the asset and click on Change Copy. Likewise you can select the Backup Copy version and click on next as usual to proceed with the restore operations. For more details on this topic, refer PowerProtect Data Manager for SQL Administration Guide. Thanks for watching.
