Install the backup agent on the Microsoft SQL Server for Cloud Management Platform and create a scheduled job for application backup in vSphere Data Protection. 

Procedure

  1. Download the backup agent on the Microsoft SQL Server machine.
    1. Open a Remote Desktop Protocol (RDP) connection to the virtual machine vra01mssql01.rainpole.local.
    2. Log in using the following credentials.

      Setting

      Value

      User name

      Windows administrator user

      Password

      windows_administrator_password

    3. Open a web browser and go to the vSphere Web Client URL https://sfo01m01vc01.sfo01.rainpole.local/vsphere-client to connect to the Management vCenter Server.
    4. Log in using the following credentials.

      Setting

      Value

      User name

      administrator@vsphere.local

      Password

      vsphere_admin_password

    5. On the vSphere Web Client Home page, click the VDP icon.
    6. On the Welcome to vSphere Data Protection page, select sfo01m01vdp01 from the VDP Appliance drop-down menu and click Connect.
    7. Click  the Configuration tab and click the Microsoft SQL Server 64 bit link in the Downloads pane. 

      The Web browser starts downloading the installer of the vSphere Data Protection backup agent. 

  2. Install the backup agent on the Microsoft SQL Server machine.
    1. After the VMwareVDPSQL-windows-x86_64_version.msi file is saved, double-click it to start the installation.

      The VMware VDP for SQL Server Setup wizard opens.

    2. On the Welcome to the VMware VDP for SQL Server Setup Wizard page, click Next.
    3. On the End-User License Agreement page, accept the end user license agreement and click Next.
    4. On the VMware VDP for SQL Server Setup, click Next to accept the default installation location for the backup agent.
    5. On the Appliance Registration Information page, enter sfo01m01vdp01.sfo01.rainpole.local in the VDP Appliance text box and click Next
    6. On the Ready to install VMware VDP for SQL Server page, click Install
    7. After the installation is complete, on the Completed the VMware VDP for SQL Server Setup Wizard page, click Finish.
  3. Create a scheduled backup job for the Microsoft SQL server.
    1. On the vSphere Web Client Home page, click the VDP icon.
    2. On the Welcome to vSphere Data Protection page, select sfo01m01vdp01 from the VDP Appliance drop-down menu and click Connect.
    3. Click the Backup tab, and from the Backup job actions menu, select New to open the Create a new backup job wizard. 
    4. On the Job Type page, select Applications and click Next.
    5. On the Data Type page, select Full Server and click Next.
    6. On the Backup Sources page, expand Microsoft SQL Server, select vra01mssql01.rainpole.local, and click Next.
    7. On the Backup Options page, leave all default values and click Next.
    8. On the Schedule page, set Backup Schedule to Daily and click Next.
    9. On the Retention Policy page, select Keep for 3 days and click Next.  
    10. On the Job Name page, enter Cloud Management Platform MSSQL Server Backups as a name for the backup job and click Next.
    11. On the Ready to Complete page, review the summary information for the backup job and click Finish.
    12. In the dialog box that shows a confirmation that the job is created, click OK.