Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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)

share|improve this question
1  
Any particular reason not to use the built-in MSSQL backup / scheduling / agent functionality? –  growse May 1 '11 at 8:45
    
We are using SQL Express - Sorry should have said –  Adam May 1 '11 at 9:22
add comment

1 Answer

up vote 2 down vote accepted

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.

share|improve this answer
    
+1 DPM is more than happy to backup the BAK files created by SQL without additional licensince. –  Chris S Jul 6 '11 at 15:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.