We have a customer who are using the SnapCenter for their SQL servers... works great, yet we have ended up with a lot of orphan snapshots on the storage systems which doesn't have any reference inside SnapCenter... for what ever reason they were not deleted... Has someone done a script that pulls out a list of snapshots out of the SnapCenter database, and compares it to the actual snapshots on the storage systems?
Sounds like a doable task? And maybe even NetApp has such a script internally?
#Looking for a cleanup script...
languid hound
minor peak
I would recommend opening a case with NetApp to investigate on why the snapshots are not getting deleted. We have seen the other way around where snapshots get deleted on the storage and SnapCenter still sees them as they are not deleted from its database.
Snapshots should be deleted per the retention that they have setup. If the snapshots are kept on the storage beyond the retention limit , we need to find the root cause on why the snapshots are not deleted.
languid hound
I would recommend opening a case with NetApp to investigate on why the snapshots...
Well this can easily happen if you keep flexclones attached over the origin snapshots expire date...