Configuring the software for SQL Server data protection in a VMware environment
To protect Microsoft SQL Server workloads that are running in a VMware ESXi virtual guest machine, install and configure Data Protection for VMware. Then, install and configure Data Protection for Microsoft SQL Server.
Before you begin
The following
list summarizes the scenario for quick reference:
- Machine name
- SQL10
- VSS requestor node name
- SQL10_VSS
- Data Protection for Microsoft SQL Server node name
- sql10_SQL
- Virtual machine
- vm_sql10
- Data mover node names
- datamover10 and datamover20
- Datacenter node name
- datacenter10
- VM file space
- \VMFULL-vm_sql10
About this task
- A single Microsoft SQL Server database on a virtual machine that is named vm_sql10 must be recovered.
- Virtual machine vm_sql10 is protected by Data Protection for VMware by using the node name datacenter10. This node name in the Tivoli® Storage Manager server represents the vSphere datacenter). The data mover nodes are called datamover10 and datamover20.
- The virtual machine guest is configured with the virtual machine display name of vm_sql10 and the Microsoft Windows machine name is SQL10.
- Data Protection for Microsoft SQL Server is installed in the guest and is configured to the Tivoli Storage Manager server to use node name sql10_SQL.
- The Tivoli Storage Manager client is configured as the VSS requestor node and is using the node name SQL10_VSS.