point-in-time restore for mssql db that has block-level backup configured

Hello @DanC 

Yes you can restore point in time as needed. You can do it all in one operation just browse the time and select PIT and it will restore all fulls, tlog, etc that are needed to that PIT.

If you want to restore just the full you can restore that in standby and apply the log backups as needed.

Yes you can also schedule a restore or clone if you are using intellisnap that is not the same as block-level. Instant clone function requires hardware array and snapshots

https://documentation.commvault.com/2022e/expert/37173_instant_clone_for_applications.html

Is there a particular reason you are using block level? If you are not using table level restores than it does not provide any unique benefits

@Scott Reynolds thank you

a bit of background on this :

#1 The dbs  use by dev team for reporting purpose

#2 db has to be restored every day to a testing server 

#3 db is about 2TB in size and we dont’ have intellisnap configured in Commvault. regular DB restore takes about 6-7 hours to complete

#4 there was a discussion in regards to large sql db restore and one of options is using block-level backup

#5 I did a test on sql block-level backup and observed that backup is 4 times faster than regular stream backup and restore save about 50% time

#6 tried db clone for a small db(~140GB) and it mount to the destination in about ~2mins where restore will take ~15mins

question :

if there is a way to schedule DB clone coz i don’t see that option in command center

there is a jason request payload for instant clone and just wondering if it can be used in Python script  so we can schedule it run daily.