Home > Storage > Data Storage Essentials > AppSync > Dell AppSync Integration with Microsoft SQL Server > SQL Server databases on VMware virtual disks
AppSync protects, mounts, and restores SQL Server databases residing on VMware virtual disks. The SQL Server instance can be clustered or non-clustered.
Following are the prerequisites and restrictions:
The following is the additional information about creating, mounting, and restoring AppSync copies of virtual disks.
Although SQL Server VDI API is used to create application-consistent copies, VSS is also used to flush I/O’s and create shadow copies of the volumes. If the ESXi version is less than 5.0, VSS is not used.
All the databases residing on the same datastore are displayed as affected entities. Restoring of virtual disks restores the entire datastore. If multiple databases are protected alongside the database being restored, they are displayed as affected entities and can be optionally recovered. Otherwise, manually detach the databases so the restore can overwrite them. They can be attached at a crash-consistent recovery.
If RecoverPoint is used, restore is at the consistency group level. If there is another datastore in the same consistency group, it is also restored. If AppSync detects any databases on that datastore, they are displayed as affected entities. If restoring in a clustered environment, ensure that all nodes of the cluster are added to AppSync. This action is done so AppSync can remove the source virtual disk from all the VMs in the cluster.