topic SnapManager for SQL 7.1 cloning database using FC block storage in Data Protection

SnapManager for SQL 7.1 cloning database using FC block storage

MGONZALEZ29 — Thu, 05 Jun 2025 05:17:06 GMT

We use FC block storage for connections from the SQL server to the Netapp SAN. I am in the testing phase of Snapmanager for SQL. Since I use block storage, I have a LUN inside a volume and the lun is setup via snapdrive. When we used Snapmanager to clone a database, we saw a new LUN clone created on the Netapp. The volume available space was cut in half as a result.

My question is that if you use block storage and not NFS/SMB, does a database clone create a lun clone and not a flexclone off the volume? This is concerning for us since if this is true, then you could fill up your volume space if we create clones via Snapmanager for SQL.

Re: SnapManager for SQL 7.1 cloning database using FC block storage

deepuj — Wed, 21 Jan 2015 08:23:17 GMT

Hi,

when we perform a clone operation on any DB the flexclone of that volume , where DB is situated ,is created.So this newly created flex vol will have the same number of luns of same size as parent vol.when we delete the clone of that DB this newly created flex vol will get deleted.Clone operaton doesnot use the space of parent volume rather creats a clone of that vol.

Thanks

Re: SnapManager for SQL 7.1 cloning database using FC block storage

deepuj — Wed, 21 Jan 2015 09:59:01 GMT

Hi,

Just to be sure

which version of ONTAP and mode are you using?

Do you have FleX clone licensed?

Are you doing this on a SnapMirror/SnapValut destination?

Thanks

Re: SnapManager for SQL 7.1 cloning database using FC block storage

MGONZALEZ29 — Thu, 19 Feb 2015 15:55:58 GMT

We are using 8.2.1. We are testing by creating a clone on the same database server but with a different database name. I'm wondering if since we don't use NFS, the clone operation can't create another volume for the clone just like how in SnapDrive, I have to manually create the volume in Netapp System Manager before I can create the lun in Snapdrive.