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 SIOS Protection Suite hierarchy before administering the new databases within Microsoft SQL Server.
To add a new volume resource to an existing SQL Server hierarchy:
- 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.
- 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 SIOS Protection Suite 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 SIOS Protection Suite specific administration.