Adding Microsoft SQL Server Volumes

As your environment grows, you may need to add new Microsoft SQL Server databases on new shared or replicated volumes. You should perform the following tasks to add the new volumes to the LifeKeeper for Windows hierarchy before administering the new databases within Microsoft SQL Server.

To add a new volume resource to an existing SQL Server hierarchy:

1. Create the resource. On the server where the SQL Server hierarchy is in service, create and extend the volume resource with the same priority order as that of the SQL hierarchy.

2. Create dependency. Right click on the SQL Server resource, and then select Create Dependency from the pop-up menu. For Child Resource Tag, select the new Volume resource.

When you have completed these LifeKeeper for Windows tasks, you can perform the administration tasks to add the SQL Server database. Adding new databases to volumes that are already part of the resource hierarchy requires no LifeKeeper for Windows specific administration.