I'm new to this netapp community. The company I work for recently switched our SAN system to Netapp. We are running Windows 2008 R2 servers, SQL 2008 R2 with snapdrive 6.3 and snapmanager 5.1.
We would like the ability to clone our databases from the latest snapshot backup and restore them to a different instance on a nightly basis as read only. I know the GUI in SMSQL allows you to do exactly what I am talking about, but there is no place that I can find that allows you to schedule the job. Ideally those clones would automatically just point to the latest nightly snapshot that is named ..._recent every night and all I would have to worry about is that the nightly snapshots happened successfully.
You can schedule a clone operation yourself using windows task scheduler or SQL Agent job.
You can try to schedule a backup first to use as an example for how to run a schedule job using SMSQL powershell cmdlet. Use the same step as the backup job, but replace with a clone-backup powershell cmdlet. You can get cmdlet reference from IAG.
Isn't there just an easy way to point the clones already created to the latest snapshot every day? I already have the clones in place where they need to be, I already have the snapshots scheduled. I just want to point the clones to the latest snapshot everytime a new one is created. It seems like that should be possible but I'm failing to find the configuration anywhere.