Hello Community
just wondering if CV supports point-in-time restore for mssql db when it has block-level backup configured for the dbs
if so, once we restore that first job, can we only need to restore tlog backups to keep the destination DB up to date ?
or can we schedule db clone ?
Best answer by Scott Reynolds
Hello
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
Hello
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
