I just found a handy page with a Microsoft-written PowerShell script for backing up a System Center Virtual Machine Manager 2008 R2 database.
You start off by writing a script with two lines:
$VMMServer = Get-VMMServer -ComputerName "<<insert the FQDN of your VMM server here>>"
Backup-VMMServer –Path "D:VMMBackups" -VMMServer $VMMServer
In the MS example, you save that as C:MyScriptsBackupVMMDatabase.ps1. I’ve tweaked it so it backs up the database to the D: drive which is probably the library drive and (hopefully) has plenty of free space.
You can create a scheduled task to run the following command (one line) for VMM 2008 R2:
PowerShell.exe -PSConsoleFile "C:Program FilesMicrosoft System Center Virtual Machine Manager 2008 R2bincli.psc1" -Command ".’C:MyScriptsBackupVMMDatabase.ps1’"
Otherwise, you can do this by hand in the Administration view –> General, and clicking the Back Up Virtual Machine Manager task in the Actions pane. You can also use a traditional SQL backup of the database. And don’t forget to backup the library file share!
EDIT #1:
You will need to change the PowerShell script execution policy. You can sign the script and se the policy to AllSigned. Or you can set it to Unrestricted.