Configure MSSQL Resource

Now that the master database has been relocated to replicated storage, the MSSQL server resources are ready to be protected using LifeKeeper. Before configuring it with LifeKeeper, start MSSQL on node-a.

1. In the LifeKeeper User Interface, define a new resource. Click the icon to start the Create Resource Wizard (on node-a). Select “Quick Service Protection” as the Recovery Kit.

2. Enter the following values. Select the default values.

Field	Value
Switchback Type	intelligent
Server	node-a

3. Select “mssql-server” for the Service Name from the dropdown list.

4. Enter the following values. Select the default values.

Field	Value
Enable or Disable Monitoring	enable
Resource Tag	QSP-mssql-server

5. The wizard reviews the values. Once it completes, click “Next >” to continue.

6. The next step is the “Pre-Extend Wizard”. Select the default values.

Field	Value
Switchback Type	intelligent
Template Priority	1
Target Priority	10

Once the checks on the ‘Pre-Extend Wizard’ have completed and passed, click ‘Next’ to continue.

7. On the “Extend gen/qsp Resource” wizard, the first choice is selecting the Database Tag. Confirm the default value and click “Extend”.

8. Once the Extend Wizard configures the gen/qsp resource, click “Finish” to complete.

9. The hierarchy has now been successfully created and verified. Click “Done” to complete.

10. Return to the LifeKeeper GUI. The “QSP-mssql-server” resource is defined as shown below.