Recovery Kit Installation

The SIOS Protection Suite Microsoft SQL Server Recovery Kit is distributed via ftp download. Installation is simple and quick using InstallShield to provide a standard installation interface.

Before installing the SIOS Protection Suite Microsoft SQL Server Recovery Kit software, be sure you are familiar with the product prerequisites. A SIOS Protection Suite Microsoft SQL Server Recovery Kit license key must be installed in order to protect a SQL resource using SIOS Protection Suite.

LifeKeeper/SQL Server Resource Installation Tips

Open the LifeKeeper Console:

• Communication paths need to be established
• Create a Resource Hierarchy on the Source
• Select the appropriate Primary/Backup Server
• For the Application to protect, select “MS SQL Server” from the drop down list
• Select Microsoft SQL Server Instance from the drop down list
• Enter Administrative User Name for {Server name}
  • Typically this is the SA account you defined in the SQL installation or an account that has permissions to the SQL Master database
• Current MSSQL Configuration for {Server name}. This is a list of all system and user defined databases as they will be moved to the mirrored volumes. Select Continue
• You will see an error message about “LifeKeeper has detected that one or more databases is located” Select OK, then Continue
• Select Destination Volume for Database Relocation
• Relocating Database(s) for {Server name}
• Select Optional Services for Protection (OPTONAL)
• Select Protected IP Address (if one has been reserved)
• Select Named Pipes Alias, none
• Microsoft SQL Server Resource Name, SQL Default or change as needed, then select Create
• Executing the pre-extend scripts, PreExtend checks were successful, select Next
• Extend Wizard
  • Select a Backup Priority for the SQL Resource on the backup server. The Backup Priority of 10 is the default. Select Extend

Upon completion a SQL resource will be displayed in the Hierarchies navigation panel of the LifeKeeper console.