Subscribe

SQL Server DB Cloning

Hi All,

Pretty new to SQL on Netapp but have a requirement to copy a live production DB from a 2005 SQL Cluster to another 2005 SQL Cluster. The live production DB needs to remain live and unaffected will need to be cloned 3 times in total. Ideally it would be best to clone the DB alone rather than the whole lun as there are a few other DB's on there.

Was hoping someone could clarify all possible options available for doing this please?

FlexClone Licenses on Order

Lun is on a FlexVolume

SnapManager for SQL is installed however not configured yet

Snapdrive is used on both clusters

Thanks

Mark

Re: SQL Server DB Cloning

another option is just a native sql backup depending on what you want to achieve.