Most Common LifeKeeper for Windows Application Solutions

The following are the most commonly requested application related solutions.

LifeKeeper/SQL installation Cheat Sheet

After the SQL Server CD/DVD or ISO media has been installed . . . . .

Via the SQL Server Installation Center

Select New installation or add features to an existing installation
Select all the defaults for the “Setup Support Files”
For Setup Role select “ SQL Server Feature Installation”
On the Feature Selection screen, select the features of your choice
- Note: Under “Shared feature Directory:” maintain the default installation path(s). During the LifeKeeper MS SQL Server installation the database will be directed to the mirrored volumes
Per the Instance Configuration select “Default instance”
Verify Disk Space Requirement, then select Next

Server Configuration:

In the dialogue box below, (bottom right) select “Use the same account for all SQL Server services”
For the Account Name and Password, a domain administrator or an account with elevated domain permission should be entered. NOTE: These credentials are required to be the same on other servers running SQL/LifeKeeper. Then select Next

Database Engine Configuration:

Authentication Mode
- Select Mixed Mode (SQL Server authentication and Windows authentication)
- Specify the password for the SQL Server system administrator (sa) account. NOTE: These credentials are required to be the same on other servers running SQL/LifeKeeper.

Specify SQL Server administrators
- Choose “Add Current User” which is a domain administrator or an account with elevated permission. SAME as from the Server Configuration portion earlier.

Analysis Service Configuration
- Choose “Add Current User” which is a domain administrator or an account with elevated permission. SAME as from the Server Configuration portion earlier

Reporting Services Configuration:

Error Reporting (Optional)

Ready to Install:

Open the LifeKeeper Console:

Comm paths need to be established
Create Resource Hierarchy on the Source
Select the appropriate Primary/Backup Server
For the Application to protect, select the drop down box for “MS SQL Server”
Select Microsoft SQL Server Instance from the drop down box
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 database 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, and then Continue again
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.

Feedback