So you have your SQL database and you are keeping a few snapshots around, mirroring them to the DR site and vaulting them to another location for true backup protection.
Ah, but you want to take an SMSQL snapshot and then keep it around for a good while to do testing and/or development. Easy enough but what you need to consider is that you are going to lock a snapshot and it won't be able to be aged out of the production. Normally you'd have to call up the storage people and ask for the volume to be split. How's about you just do the job yourself and save everyone time. Obviously you need permissions on the controller (storage admin will provide easily enough and you need to be responsible for your own aggregate. Don't fill it up !!
Two PowerShell commandlets will FlexClone the snapshot so that you can start using it. Then, later, if you want to have that around on those disks for longer than your normal snapshot retention pattern you can execute the split. The FlexClone Split command is a background process so the LUN doesn't go offline ever, the underlying FlexVol just silently inflates on the aggregate.
New-NaVolClone -ParentVolume test1 -ParentSnapshot snapshot101 -CloneVolume testclone -Controller $Filer
Start-NaVolCloneSplit -name testclone -Controller $Filer

0 comments:
Post a Comment