Best Practice for Backup of SQL Server on Hyper-V machine
Posted on 2011-10-12
I recently virtualized a SQL Server 2005 server onto a Hyper-V system. The guest OS is Windows Server 2008 R2.
I've got a Hyper-V Remote Agent for Backup Exec 2010 R3 that backs up the Hyper-V host and all its guest OSs. It doesn't allow for granular restores of SQL databases, but I am running the native SQL Server backups in a maintenance plan.
The old physical server had been using a SQL Server Remote agent, which is now available to be moved to the virtualized SQL Server. It does allow for granular restores.
So, I'm looking for the best combination of my resources for backing up my virtualized SQL Server. Your suggestions?