• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Best Practice for Backup of SQL Server on Hyper-V machine

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?
0
anordquist
Asked:
anordquist
2 Solutions
 
Aaron TomoskyTechnology ConsultantCommented:
As I've ha Ba experience with backup software and SQL, I've sinced moved to a simple sqlcmd script that creates .bak files of my databases and I let the backup software back those up. Since they are nice unlocked files, I don't need anything special, any software can do it.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
SQL Backups can be done independently from system backups.  SQL backups guarantee application transaction coherent databases at restore time which can not be seen from the perspective of the system.  At restore time, restore the most recent system backup  then restore the nearest SQL backup.

Hope this helps...
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now