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.
- Install StoreVault Manager 3.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 - Install SnapManager for SQL 2.11
- 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.
- Now launch StoreVault Manager and Log onto the SAN that you would like to create the LUN’s on.
- 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.
- 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.
- Launch SnapManager and follow the Wizard.
- 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.
STBDesk can not read schemas table
October 10, 2008 by John Tran · Leave a Comment
If you’re trying to launch STB Detector and you receive the following error ‘StbDesk’ can not read ’schemas’ table, then your configuration path in your registry is incorrect.
To correct this problem do the following,
- Open regedit
- Go to HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine
- Double Click on CONFIGFILE01
- Now insert the correct path for the configuration file, usually the path is found in the configuration folder in the STB Detector home folder. The file name is usually STB_DETECTOR.CFG
Checkpoint VPN-1 not working with 3G/HSDPA/GPRS/EDGE Mobile Broadband
October 8, 2008 by John Tran · Leave a Comment
If you’re using Checkpoint VPN via a Mobile Broadband connection using either 3G, HSDPA, GPRS or Edge and you get a gateway not responding error message.
You will need to uninstall the Checkpoint VPN software and reinstall the application whilst connected to the internet with your Mobile Broadband connection.
If this still doesn’t work then you need to contact your provider and ask if VPN port is available on your current plan.