SnapManager for SQL Configuration Wizard


In this tutorial I will guide you through the SnapManager for SQL Configuration Wizard. You must have SnapDrive installed and configured with your Lun layout and SnapManager for SQL installed.

1. Launch the SnapManager for SQL Application. On first launch it will automatically pop up and tell you that you have no server configured, click ok to configure a server now. Once you click ok and select a server the SnapManager Configuration Wizard will launch. You can also launch the SnapManager Configuration Wizard manually by right clicking on the added server and select Configuration Wizard. Once the Wizard launches click next.

2. It is advisable to run your verification server separately so you don’t put excess load on your production server. I have created another Windows 2008 R2 server for verification. It’s hostname is verify for lab purposes. (The verification server must have snapdrive, snapmanager for sql and sql server installed). I will be connecting using Windows Authentication. Click Next.

3. On page 99 of the SnapManager for SQL Admin and Installation Guide, you will find various layout options for your database, logs and snapinfo directory. I have gone with the following layout for this lab: Databases over 1GB have a dedicated lun for the database files and a separate lun for logs, Databases less than 1GB are all contained on one lun, N: with their log files contained on a separate lun, L:. The snapinfo directory is contained in it’s own lun, S:. An important point to remember with database layouts is that multiple databases on a single lun can only be restored using the streaming method, ie copy base. Database contained in their own volume and lun can use snapshot based, hence the reason for placing large databases in their own lun. To avoid the limitation of exhausting drive letters, volume mount points are also supported in SnapManager for SQL.

4. I will only be using a single snapinfo directory. Click Next.

5. I will be using R: for my snapinfo drive. Click Next.

6. You have a few self explanatory options here, they are quite straight forward so I won’t dive into them. Click Next.

7. Enter in your SMTP server, from address, to address and subject. Select if you wish to send AutoSupport messages. Click Next.

8. A summary of any changes you have made through the wizard will be displayed here. Click Finish.

If you have any technical questions about this tutorial or any other tutorials on this site, please open a new thread in the forums and the community will be able to help you out.

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.