SQL Server backup app

Question

We are using DPM 2010 to backup our Hyper-V cluster however we require an client/agent and server SQL backup app for all of our Windows VMs, as to purchase an Enterprise DPM licence for each VM is to expensive.

Any good ones? (Its need to be able to Backup MS SQL on schedule to a standard SQL backup file on disk)

Answer 1

You can script a backup of the databases using SSMS and then save the script and then call the script from a batch file using sqlcmd.exe and then create a scheduled task that executes the batch file. Google is chock full of examples.