Quick Guide to Creating SQL LUN’s and Installing SnapManager for SQL

This is just a quick guide to creating SQL LUN’s and installing SnapManager for SQL.  If you would like a comprehensive guide then you will need to download the SMSQL – InstallAndAdminGuide.pdf file from Storevault Support.  You will need to register to gain access to the download page.

To begin you will need to make sure that you have the following software packages, StoreVault Manager 3.2, SnapDrive 5.0 and SnapManager for SQL 2.11.  If you do not have these packages you can download them from Storevault Support.  Once you have obtained the necessary packages do the following.

NOTE:  You will need to install all packages on the SQL Server that you would like to backup.

1. Install StoreVault Manager 3.2
2. Install SnapDrive 5.0. You may need to install the Windows 2003 Server Hotfix KB931300 – Snapshot volumes do not mount successfully or the volume dismount operation reports an error when you use a Network Appliance storage device with the Windows Server 2003 Virtual Disk Service.Click here to download x64 Version
   Click here to download x86 Version
3. Install SnapManager for SQL 2.11
4. Install ISCSI Software Initiator.  You can download ISCSI Software Initiator from here if you do not have a copy.  Once you have installed the ISCSI Initiator make sure you launch the application and add the ISCSI target and obtain the ISCSI Name, eg. qn.1998-01.com.vmware:vmwareserver01-69g33239.
5. Now launch StoreVault Manager and Log onto the SAN that you would like to create the LUN’s on.
6. Click Create LUN (SAN) and go through the Create LUN Wizard.  Make sure you select MS SQL Database as the LUN Application Type as shown below.
   
   
7. You will also need to add the ISCSI Name of the host and StoreVault will automatically attach the LUN to the host.  Once you complete the Wizard, the LUN will appear under My Computer.
8. Launch SnapManager and follow the Wizard.
9. You will need to migrate all your databases to the newly created LUN’s.  Best practise is to have a seperate LUN for your Databases, Logs and SnapInfo.  Databases that are stored on local disk will not be able to be backed up using SnapManager for SQL.