Prerequisites for configuring virtual machines for backup

Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

Enterprise Workloads Editions: File:/tick.png Business File:/cross.png Enterprise File:/tick.png Elite

 

Before you begin, ensure that you have reviewed the Support matrix

Prerequisites for SQL Server application aware backups

Note: The Windows account configured must be a local administrator account or should be a part of the Administrators group. Appaware backup is not supported for non-administrator user accounts.


sysdamin_permissions.png

Permission Description
Administrator Required for SQL Server backup and restores.
Sysadmin Required for SQL Server backup and restores. 

Key considerations for SQL Server application aware backups

The following are some of the key considerations for SQL Server application aware backups:

Other considerations for configuring VMware for backup

The following are some of the key considerations for configuring VMware for backup:

Note: MS SQL backups and VMware backups of the same virtual machine must start at different times to avoid backup errors. Ensure that the backups windows do not overlap.  

Limitations 

  • Druva does not support backup of mirrored SQL server databases. Druva excludes such databases from backup. 
  • SQL Server aware backups are not available for availability groups at the moment. 
  • SQL Server AppAware backups do not support SQL filestream databases.
  • SQL Server aware backups are not available for failover clustered instances (FCIs) at the moment. 
  • SQL database restores from VMs with NVMe controllers or disk are not supported. Full VM restores having app-aware policy configured will restore such databases as part of VM restores.
  • If the backup proxy is unencrypted, and the virtual machine that is getting backed up through HotAdd is encrypted:

    • Transport mode is changed to NBDSSL, and the virtual machine is backed up successfully

    • When you restore the virtual machine, it is restored as an unencrypted virtual machine.

  • You cannot use all four DNS server addresses if:

    • You have enabled both network interface cards in the backup proxy

    • Both cards are configured to use different networks

    • Both cards use two domain naming systems each

  • Due to Druva backup proxy limitations, when you add DNS server addresses, three out of four DNS addresses are used based on the sequence of network interface cards you configure.

  • System databases are not protected as part of VMware application-aware MS SQL backups. Use the MS SQL Server agent to protect MS SQL system databases.

Prerequisites for configuring virtual machines for Instant Restore

  • Make sure you have deployed and configured CloudCache for local storage.

  • VM proxy, ESXI host and Cloud Cache should be able to ping and resolve to each other bi-directionally 

    Ports required to be opened on Cloud Cache are:

    443      : For Backups
    111       : Port mapper
    2049    : For NFS service, to create a temporary NFS datastore on the ESXI host.
    49152  : Instant restore service
    49153  : Instant restore service

    Ports required to be opened on ESXI host are:

    111   : Port mapper
    2049  : For NFS service, to create a temporary NFS datastore on the ESXI host.
    49152 : Instant restore service
  • Make sure that the virtual machine you want to restore instantly is mapped to the Linux CloudCache version 4.1 and later for backup.
  • Make sure that you have enabled instant restore for the virtual machine.
  • Make sure that you have at least one instant restore supported proxy (version 5.0.5.x or later) that is in a connected state in the proxy pool.

  • Add permissions to backup proxy to create a datastore, or to migrate a Hot or Cold VM. For more information, see Required vCenter or ESXi user permissions for backup, restore, and OVA deployment.
  • Instant restore and migrate to production jobs support staging datastores. A staging datastore is a datastore on an ESXi host that stores all changes to the instantly restored virtual machine.

  • Migrate to production job for a VM cannot reuse the staging datastore used for the instant restore job of that VM. If you want to migrate a virtual machine to production, ensure you have another datastore on the same or different ESXi host, depending on whether you are migrating to the same or alternate host.

Key considerations for Instant Restore of virtual machines

  • If you switch to a Windows CloudCache after enabling Instant Restore, the Instant Restore is disabled for the selected VMs.

  • Instant restore of virtual machines is supported from Hot restore points only.

  • If you dissociate a VM from CloudCache, all the subsequent backups of the VM will be stored directly on the Druva Ccloud, and instant restoration of the VM is not possible.

  • Deleting an instantly restored VM dissipates it from CloudCache and cannot be recovered later. 

  • For better performance, we recommend that you migrate the instantly restored VMs within a week.

  • We recommend that you do not use an old restore point (RP) as compaction kicks in if the RPs fall out of the retention period.

  • We recommend that you do not restart Linux CloudCache during instant restore or migration as that causes failure of the respective jobs.

Prerequisites for HotAdd transport

For HotAdd transport mode to work correctly following are the pre-requisites:

  1. The datastore on which the backup proxy is created must be formatted with the right block size to be able to mount the largest virtual disk of the hot added virtual machines. The block size limitations vary across VMFS, VMFS-2, VMFS-3 and VMFS-5 for a given virtual disk size. For details on the block size requirements, please refer to theVMware kb article.

  2. The proxy being used to backup the virtual machine must be a Virtual Machine on a host that is able to access data store, where the source virtual machine's disk are stored.

  3. In versions 5.1 and older of vSphere, the maximum supported VMDK size is 1.98 TB

  4. The disks that are to be HotAdd must be SCSI. IDE drives are not compatible with HotAdd.

  5. The datastore of the source virtual machine and the datastore of the backup proxy should be of the same blocksize.

  6. To back up virtual machines with NVMe disks or NVMe controllers using the HotAdd transport mode, ensure that you've performed a new deployment of VMware Backup proxy version 6.0.3-178504. If you're using an older Backup proxy, ensure that you manually perform the steps explained under Existing backup proxies at versions lower than 6.0.0 -147290.

Note: If any of the above conditions are not met then the backup will fail over to NBD/NBDSSL.

  Limitations with HotAdd

  1. HotAdd may fail if any disk was created with a newer hardware version than the virtual machine being backed up.

  2. For example, if a disk was moved from a hardware version 8 virtual machine to a hardware version 7 virtual machine. To resolve, upgrade the hardware version of the virtual machine.

  3. A single SCSI controller can have a maximum of 15 disks attached. To run multiple concurrent jobs with more than 15 disks, you need to add more SCSI controllers to your backup proxy that is responsible for hot adding the disks. (KB article).

  4. HotAdd may fail if you are trying to back up the virtual machine through the host added as a standalone server, but actually being managed by vCenter.

  5. Hot Add may fail if the virtual machine you are trying to back up and the backup proxy are in different clusters.

  6. The backups will fail if you have set HotAdd as a transport mode in the Phoenix.cfg file for the VMs having NVMe disks and the proxies are not upgraded.

Related topic

Required vCenter or ESXi user permissions for backup and restore