Backup-SCVMMServer

Syntax

Backup-SCVMMServer
      -Path <String>
      [-VMMServer <ServerConnection>]
      [-RunAsynchronously]
      [-PROTipID <Guid>]
      [-JobVariable <String>]
      [<CommonParameters>]

Description

The Backup-SCVMMServer cmdlet backs up the Virtual Machine Manager (VMM) database on a VMM server to a local folder or to a remote network share. The folder to which you back up the database must be accessible to the SQL Server.

To Determine Whether SQL Server is Local or on a Remote Server

If you do not know whether the VMM database is stored locally or on a remote server running Microsoft SQL Server, do the following:

1. On the VMM server, open the Registry Editor. 2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft System Center Virtual Machine Manager Server\Settings\Sql 3. Look at the value for OnRemoteServer:

-- If it is set to 0, the database is on the local VMM server. 

-- If it is set to 1, the database is on a remote SQL server.

Restoring the Backed-up Database

After you use the Backup-SCVMMServer cmdlet to back up the VMM database (see Examples 1 and 2), you can use the SCVMMRecover.exe command to restore the database (see Example 3). This command, which is not a Windows PowerShell cmdlet, is installed with VMM. By default, SCVMMRecover.exe is installed at <%system-drive%>\Program Files\Microsoft System Center 2016\Virtual Machine Manager\bin.

Important: To back up and restore a server functioning as a virtual machine host or as a library server in a VMM environment, use your standard server backup and restore procedures.

Examples

Example 1: Back up the VMM database to a local folder

PS C:\> Backup-SCVMMServer -VMMServer "VMMServer01.Contoso.com" -Path "D:\VMMBackups"

This command backs up the VMM database on the VMM server named VMMServer01 to the specified path.

Notes:

• Backup-SCVMMServer must back up the database to a server running SQL Server. This example assumes that SQL Server (for the VMM database) is installed on VMMServer01 rather than on a remote server.

• When you back up the database to a local folder, the folder must be write-accessible to the SQL Server service.

Example 2: Back up the VMM database to a network share

PS C:\> Backup-SCVMMServer -VMMServer "VMMServer01.Contoso.com" -Path "\\SQLServer01\VMMBackups"

This command backs up the VMM database on the VMM server named VMMServer01 to the specified share on a server named SQLServer01.

Important:

• Backup-SCVMMServer must back up the database to a server running SQL Server, so this example assumes that SQL Server (for the VMM database) is installed on SQLServer01.
• When you back up the database to a remote share, the share must be write-accessible to the SQL Server service.

Example 3: Restore the VMM database

C:\> SCVMMRecover.exe -Path <%backup-folder-path%>\<%backup-file-name%>.bak -Confirm

This example demonstrates the use of SCVMMRecover.exe, and not a PowerShell cmdlet. You must open a command prompt window (not a PowerShell window) and use the SCVMMRecover.exe command that is installed with VMM to perform this operation. You must run SCVMMRecover.exe locally on the VMM server on which you want to restore the database. SCVMMRecover.exe does not work with a highly available VMM installation.

This example restores the VMM database to the VMM server where:

<%backup-folder-path%> is the path on the server running SQL Server where the .bak file is saved. <%backup-file-name%> is the name of the .bak file that was created during the backup operation.

This example assumes that SCVMMRecover.exe is installed in the default location for VMM at <%system-drive%>\Program Files\Microsoft System Center 2016\Virtual Machine Manager\bin\SCVMMRecover.exe

Parameters

-JobVariable

-Path

-PROTipID

-RunAsynchronously

-VMMServer

Outputs

VMMServer

This cmdlet returns a VMMServer object.

Related Links

• Get-SCVMMServer
• Set-SCVMMServer