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, click the “Operations” dropdown and select “Create Resource Hierarchy” Select “Quick Service Protection” as the Recovery Kit. Click “NEXT”.

2. Select “mssql-server” for the Service Name from the dropdown list. Click “NEXT”.

3. Enter or select the following values. Click “NEXT”.

Field	Value
Quick Service Protection Resource Tag	QSP-mssql-server
Switchback type	Intelligent
Monitoring (quickCheck)	enable

4. The wizard reviews the values. Once it completes, click “EXECUTE” to continue.

5. Once you confirm the resource is successfully created, click “EXTEND RESOURCE HIERARCHY”.

6. On the “Extend Resource Hierarchy” wizard, confirm the default values and click “NEXT”.

7. Once the Pre-Extend checks are performed, select or enter additional settings. Click “NEXT”.

Field	Value
Switchback Type	intelligent
Resource	QSP-msql-server

8. The wizard reviews the values. Once it completes, click “EXECUTE”.

9. The verification is now complete. Click “CLOSE” to exit the dialog. To extend the extended resource hierarchy to another server in the cluster, select the “EXTEND THIS RESOURCE TO ANOTHER SERVER” button.

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