restores from snapshot of SnapCenter SQL plugin

FelixZhou · ‎2022-09-22

looks we have three restore options from SnapCenter SQL plug in snapshot, restore, clone and migrate. Does anyone have more details about the difference on these three.

Believe the clone will present snapshot luns to the host through new igroup, make the SQL database available right way. will the clone split run in the background and make the SQL database available during the split? will the split faster than the restore?

Seems the restore also presents luns to the host. we got 250MB/sec from restore. doesn't good as we thought.

Not sure about migrate, will migrate move SQL between clusters?

Please point me out if i understand incorrectly and provide more details if you have.

thanks,

Ontapforrum · ‎2022-09-23

Clone - is instant (much faster compared to restore) - as you said, sql db is made available right away.
Restore - (clone-split) This is much slower compared to just cloning.

will the split faster than the restore?

I am not sure I get it, but restore requires split.
Why does flex volume clone split take a long time?
https://kb.netapp.com/Advice_and_Troubleshooting/Data_Storage_Software/ONTAP_OS/Why_does_flex_volume_clone_split_take_a_long_time

Is there an alternative for a FlexClone split that retains the snapshots in the FlexClone volume?
https://kb.netapp.com/Advice_and_Troubleshooting/Data_Storage_Software/ONTAP_OS/FAQ_-_FlexClone_split

Migrate - Do you mean migrate resources?
https://docs.netapp.com/us-en/snapcenter/protect-scsql/task_migrate_resources_to_netapp_storage.html#:~:text=In%20the%20left%20navigation%20pane%2C%20....