In this tutorial I will guide you through the SnapManager for SQL Clone Wizard. With the Clone wizard you can clone a live database or clone a database from an existing backup set.
1. Launch the SnapManager for SQL application.











All the tutorials included on this site are performed in a lab environment to simulate a real world production scenario. As everything is done to provide the most accurate steps to date, we take no responsibility if you implement any of these steps in a production environment.
I am having query regarding SnapManager clone wizard.After cloning is completed, normal database is created on respective instance which is as usual.But when I tried to take backup of cloned database through snapmanger again then it doesn’t allow me to even select that database..it shows as greyed out or disabled for taking backup. Why it is not allowed ? how snapmanager deals with cloned database ?
Hi Sada, after creating a cloned database, re-run the snapmanager configuration wizard and make sure the database is in the correct volumes etc
Hi David..thanks for reply…..Cloned database files are created in separate mounted volumes which are getting created each time during cloning process…is there any volume specific configuration defined in SnapManager which is used to identify database that can be backed up…how it works?
Hi Sada yes, it needs to be laid out correctly. If you run the snapmanager configuration wizard after the cloning process you will be able to see the databases that are not in the locations that snapmanager likes. If they are not in the right locations then you cannot back it up. For example we use a volume for database1, a separate volume for database1logs, and finally a separate volume for the snapinfo directory.
hi David, can we specifiy multiple volumes thru configuration wizard..if possible please send screenshot for the same also it will be highly helpful….if you can send download link for snapmanager evaluation copy….
Hi Sada, yes you can select the database and then say I want the database files to sit in this volume and the logs to sit in this other volume and the snapinfo for that database to sit in another volume. The eval copy can downloaded from http://now.netapp.com