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.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment